csv import into excel, preserving leading zeros in numbers

  • Thread starter Thread starter Vadim
  • Start date Start date
V

Vadim

Hi,
We have csv file automatically generated where rows look like:
"0123","04567","089".
The problem is that when Excel opens this file it puts it into cells like
123,456,89
stripping leading zeros. Is there way to generate csv file so that leading
zeros won't be stripped so it would like
0123,0456,089 when the file is opened in excel.

Thank you

Vadim
 
Hi Vadim,

rename the file a .txt file. Then you will have a choice for the type of
field, number or text
 

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

Stripping leading zeros 2
Text Output To CSV 5
Display leading zeros 2
Zip Codes Dropping Leading Zero 3
Losing leading 0 when saving as .csv 2
Converting .txt file to Excel 1
Open CSV as txt data 5
CSV file dropping lead zeros 1

Back
Top