excel xls to csv numbers stored as txt lose first 0

  • Thread starter Thread starter steve44122
  • Start date Start date
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
 
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

Convert csv to Excel files 1
Cell format on reading .csv file 3
csv not importing numbers stored as text 1
Saving as CSV File 2
Open csv file with Leading Zeros 1
Reading CSV with numbers in text format, Excel automatically convertsto scientific notation 1
CSV to Excel 3
CSV->Excel Data Problem 1

Back
Top