If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
format change on paste
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/ |
Thread Tools | |
Display Modes | |
|
|