Leadin 0s

  • Thread starter Thread starter xcao
  • Start date Start date
X

xcao

We import from data from a student application software.

After exporting to Excel, it drops the leading 0s in a feild called
OtherID.

After I format the cells to text , adding 0s and save it again to .cvs
file, it drops the 0s again.

Is there any way for us to keep the leading 0s in .csv file.

Thanks
 
Use notepad to look at the .csv file. You should see the leading 0's there.

The leading 0's get lost when you open that file in excel.
 

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

Entering multiple literal values in a spreadsheet 1
How to open a csv file without auto converion 2
Pivot Table 1
leading 0s in zipcode missing when exporting to csv file 6
Gridview to XLS... formatting issues 1
Paste link only - not value 4
Date conversion 8
Sort serial numbers that contain a letter, by number 7

Back
Top