Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Leading zeroes in ZIP field
How do I stop losing the leading zero in a ZIP code field in a .csv file?
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Leading zeroes in ZIP field
Hi Kate,
You could format the cells with the zip code format (Format|Cells|Special). Cheers -- macropod [MVP - Microsoft Word] "KateB" wrote in message ... How do I stop losing the leading zero in a ZIP code field in a .csv file? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Leading zeroes in ZIP field
If you see the leading 0's in excel before you save the data in a .csv file,
then the 0's are still there. But don't open the .csv file in excel to check it. (That's the part that's losing the leading 0's.) Just open that .csv file in Notepad or some other text editor. KateB wrote: How do I stop losing the leading zero in a ZIP code field in a .csv file? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Leading zeroes get dropped when converted to text | Excel Discussion (Misc queries) | |||
How to keep leading zero without changing field to text field? | Excel Discussion (Misc queries) | |||
how to keep leading zeroes when saving in xls in csv format | Excel Discussion (Misc queries) | |||
save text field w/ leading zeros in .csv format & not lose zeros? | Excel Discussion (Misc queries) | |||
CSV leading zeroes | Excel Discussion (Misc queries) |