format change on paste

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.

What can be causing this?
 
B

BrianB

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

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