Keeping leading zeros in imported data (one digit month as 05)



I am importing a csv into Excel. I need to retain leading zeros that occur
in a MMDD format. So that May 5th appears 0505 on csv but when imported it
appears 505. How can I do that easily?

Peo Sjoblom

Rename the file to your_name.txt and the text import wizard will open, in
step 3 you can select text under column data, that will keep leading zeros.
You can also open the csv file doing data>import external data>import data
then in the file name type *.*, then find your csv file and open it, that
will also trigger the text import wizard



Peo Sjoblom

Dave Peterson

You could format the cell after you bring in your data
(Format|cells|Number tab|Custom category: 0000)

Or you could rename your .csv file to .txt. Then when you do file|open, you'll
get the text import wizard and you can tell excel to treat this field as text.

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