excel xls to csv numbers stored as txt lose first 0

S

steve44122

we have a mix field with some having only numbers. it is text. when
converting it to a csv the 0 in the first column are lost.... this happens
only to fields that are only numeric
 
S

Sean Timmons

When you change to .CSV, Excel reformats each field as it deems fit. You
could either add a ' prior to each number or format as text after conversion,
then add leading 0's...
 

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

Similar Threads

Reading CSV with numbers in text format, Excel automatically convertsto scientific notation 1
csv not importing numbers stored as text 1
converting telephone numbers to csv format! 3
CSV to Excel 3
Convert csv to Excel files 1
Saving as CSV File 2
Converting xls to CSV file - dropping leading 0s 1
Open csv file with Leading Zeros 1

Top