At work I have to export a report into Excel. We have some very long quote numbers that get abbreviated to scientific notation in the process. When I click on the cell, I see the entire length of the quote number except the last digit is changed to '0.' Verifying the correct quote number adds considerable work. Is there a way to configure Excel to not automatically change the number format when I export?
Thank you for your help.
Last edited by johnrriggs22; 12-13-2010 at 11:40 AM.
Excel has some limitations on the length of actual numerics it can process as numbers. However, if these account codes are simply for reference (you never add account codes. right?), then having Excel import that particular column of values as TEXT should solve the display problem.
Format the target column as TEXT prior to the import, or change your import routine to specifically select that column of values and mark it as TEXT during the import.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Thank you for your help, JBeaucaire. I was afraid I couldn't turn off the auto-format for long numbers sinceI I didn't see anything in the options. sadly, the export function is hard-coded into the report so I can't change it.
Thank you, though.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks