format changes when pasting to Excel

G

Glenn McKinlay

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. Both should be the same.

What can be causing this?
 
Top