Save as CSV and Retain Leading zero

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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

CSV File - Leading Zeros 2
leading zero & .csv files 4
Open csv file with Leading Zeros 1
Reading CSV with numbers in text format, Excel automatically convertsto scientific notation 1
Numeric values as character in CSV 3
converting 5
Keeping leading zeros in imported data (one digit month as 05) 2
Importing to Excel from csv AND keep leading zeros 2

Back
Top