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

G

Guest

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?
 
P

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


--


Regards,


Peo Sjoblom
 
D

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

Similar Threads

Open csv file with Leading Zeros 1
Leading zeros 2
How do I stop Excel from dropping leading zeros? 9
Loosing Leading zeros in CSV file 2
How do I retain leading zero zip code formatting when saving as a. 7
Need 7 digit number with differnt number of leading zeros 10
Stop automatically removing leading zeros? 2
retain leading zeros when importing 1

Top