Help exporting numbers as text to Excel

J

Jeff Schneider

I'm trying to export serial numbers stored as text. These serial numbers are
13-digits long and can include leading zeros (thus, storing as text). When
exporting the report to Excel, the leading zero is being dropped and they are
being converted to scientific notation. How do I keep them as text?
 
M

MH

Try exporting them with an apostrophe at the beginning (on English keyboards
it's on the same key as the @ symbol).

Excel is a real PITA as it automatically formats data into whatever format
it thinks best and there is no way to turn it off.

MH
 

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

Top