Leadin 0s

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
 
D

Dave Peterson

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
Leading 0s in zip codes suppressed - should be text or zip format 2
Pivot Table 1
leading 0s in zipcode missing when exporting to csv file 6
Date conversion 8
Sort serial numbers that contain a letter, by number 7
Paste link only - not value 4
leading 0s omitted when exporting to Excel 1

Top