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.