CSV File - Leading Zeros


G

Guest

I am opening a common delimted file in Excel and formating 2 fields as "text"
to retain leading zeros. They appear correctly in Excel. I then need to
save as a "csv" file and retain the leading zeros. How can I do this? The
zero's always drop off in the csv file when retrieved again in excel.

TIA
 
Ad

Advertisements

G

Guest

hi,

do you need to save the csv every time, if you save I agree it will remove
the zeros.

There is no perfect solution to this but if your file format is standard,
you may consider preparing a excel template with the repeate, concencanate
and left and right formula.

This will fill a particular cell with appropriate number of zeros base on
the number of digits you have in the cell.

thanks,
Hitesh
 
Ad

Advertisements

D

Dave Peterson

Rename your .csv file to .txt and when you import it, you can tell excel to
treat the field as 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

Top