Keeping leading zeros in imported data (one digit month as 05)
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 dataimport external dataimport 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
"exito816" wrote in message
...
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?
|