Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Leading 0s in zip codes suppressed - should be text or zip format
I have a data file that was given to me in .xls format - and all of the
leading 0s have been suppressed. How do I get them back? Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
leading zeros in text format | Excel Discussion (Misc queries) | |||
zip codes without losing leading zero from csv | Excel Discussion (Misc queries) | |||
formating zip codes with leading zero to print zero | Excel Discussion (Misc queries) | |||
zip codes not being saved as text in CSV format | Excel Discussion (Misc queries) | |||
how do I input zip codes with a leading zero | New Users to Excel |