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
 
Ad

Advertisements

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

Top