format change on paste

I am pasting data from an Access query into an excel
template and getting inexplicable cell format changes.

I preset the format on all cells in a column to text.
In Access I run the query select all the results and
Edit/Copy
Switch to Excel and paste my data using Edit/Paste/Paste
special/text
My data comes up with some cells changed formal,
for example one cell A6 has 203960500 in text format but
cell A7 has changed to currency format and displays
$2,039,605,00.

What can be causing this?

What can be causing this?
The short answer is ... Access (grin).

I get round this by setting queries to "Make Table" and importing into
Excel. Saves a lot of hassle. Can still give some problems, but we seem
to get a bit more control.



---
Message posted from http://www.ExcelForum.com/