Preserving '00nnnn' in xls to csv file saving

T

Tom

Excel 2003 SP3

I have a couple of columns, such as WorkType and ZipCode that have leading
zeroes. For example, a ZipCode could be '00141', '02099' etc. and the
WorkType could be '0800', '1000', '0100' etc. I've changed the column format
from General to Special ('00000') and tried Text and also tried saving as CSV
(MS-DOS). I can't setup the entire spreadsheet as Text or whatever because I
have a column of dates and times, phone numbers, city, ....

What's the way to save a spreadsheet so that my columns with leading zeroes
in the cell don't get dropped? Seems easy and I remember doing this a while
back but I can't seem to find the solution now....! :-(
TIA!
 
D

Dave Peterson

The leading 0's don't get lost when you saved the file as a .csv file. Use
notepad to check it out.

But if you reopen that .csv file in excel, those leading 0's will be lost.
 

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

Reading CSV with numbers in text format, Excel automatically convertsto scientific notation 1
Adding data to MS Access from csv file 0
Trying to create custom labels from an csv file + Need items numerically counted out 0
How to center adjust text above and image in a two column document. 1
Active Content in this file is blocked issue 1
CSV->Excel Data Problem 1
how to keep leading zeroes when saving in xls in csv format 2
Option for opening Excel .csv in text vs. general 7

Top