format change on paste

  • Thread starter Thread starter glenn mckinlay
  • Start date Start date
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?
 
<<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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Remove date format? 3
retain custom date format "text" when pasting or reformatting data 2
Formatting not protected when paste 7
paste web without date format 1
My cell format changes unexpectedly after copy/paste 1
Excel 2007 Problem Paste/Enter Key 0
Copy paste data from a column to a row 0
Paste Special Values 2

Back
Top