Number in text format in CSV file

M

mewild58

16 digit number formatted as text in a csv file is truncated when the csv
file is opened in Excel ... actually the 16th digit is changed to a 0. For
example, in the csv file, the text 1000000001423086 is shown as
1000000001423080 when the csv file is opened with Excel. Is there a setting
in Excel 2003 and/or 2007 that will prevent this from happening? This
specifically is invoice information generated by one system for loading into
another so it's really important for the invoice numbers to be correct!
 
M

mewild58

Thanks, Dave. I just saw that in another post about renaming the .csv file
as .txt and then specify the format of each column. This will actually solve
a few other issues that I'm having to manually correct each time I do the
upload. Thanks again.
 
S

Shane Devenshire

Hi,

when you import a txt file the Import Wizard allows you to specify in step 3
that any specified column (field) should be treated as text. So to get this
to work don't copy the file, open the .csv from inside of Excel.
 
M

mewild58

Opening the .csv file in Excel is what got me into this. Saving or renaming
the file as .txt then opening it from within Excel and going through the
wizard will work beautifully.
 

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