Save as CSV and Retain Leading zero

G

Guest

I would like to Save As .csv and retain a leading zero for uploading into a
Yahoo shopper.

When I format the cell using Custom 000000 and save the file as .csv and
open it again the leading zero is missing.

Sample number to save as .csv
012345
023456
034567
 
R

RichardSchollar

Hi Craig

This is an example of Excel being too 'helpful' - the leading zero
shouldn't be dropped (try opening the csv file in Notepad after saving
from Excel - the leading zero should still be there). It is only when
you open a csv in Excel does Excel convert field values to what it
considers are numerics (no leading zeroes).

Best regards

Richard
 

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

leading zero & .csv files 4
converting 5
Numeric values as character in CSV 3
CSV File - Leading Zeros 2
Leading Zero dropping off after export to Excel 3
How can I retain leading zeroes when saving as a CSV file? 1
save text field w/ leading zeros in .csv format & not lose zeros? 1
Open csv file with Leading Zeros 1

Top