csv import into excel, preserving leading zeros in numbers

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
 
N

Niek Otten

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

Open CSV as txt data 5
Leading Zeros are lost when importing spreadsheet data 7
Open csv file with Leading Zeros 1
How to stop Excel from automatically truncating leading zeros 2
Losing leading 0 when saving as .csv 2
Importing to Excel from csv AND keep leading zeros 2
Leading Zeros - CSV File 6
Stopping Excel from stripping off leading zeros? 2

Top