Keeping leading zeros in imported data (one digit month as 05)
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.
exito816 wrote:
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?
--
Dave Peterson
|