Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to copy a number into a text cell, keeping leading zeros? | Charts and Charting in Excel | |||
Remove leading zeros from downloaded data | Excel Discussion (Misc queries) | |||
format cell to show leading zeros and make cell a three digit fiel | Excel Worksheet Functions | |||
How to program data entry to avoid zeros or last 5 digit. | Excel Discussion (Misc queries) | |||
How do I eliminate leading zeros from downloaded data? | Excel Worksheet Functions |