View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default Prevent Scientific Notation

The problem is not converting to scientific. Even if the 'numbers' stayed as
General, the last few digits would be converted to zeros since Excel has
15-digit precision. If the 'numbers' are given to Excel as text then no
conversion will occur.
best wishes

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"robbyp" wrote in message
...
I am running an Access program that exports data into an Excel spreadsheet.
The problem I am having is that I have a FedEx tracking # field that
displays
in scientific notation because it's longer than 12 digits. Since this
program
is automated I cannot count on someone to manually change this field to
text
before the data is used.

Is there a way to prevent Excel from converting to scientific notation, or
at least change the amount of numbers that must be present before doing
so?
Thanks.