| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i keep zip code zeros from disappearing
Excel 2003 Have tried formatting the column/cells in special format for
zips - no go Tried text format, them apostrophe before zip - did n't work Help |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do i keep zip code zeros from disappearing
format - custom 00000 should work
cheers "debh" wrote: Excel 2003 Have tried formatting the column/cells in special format for zips - no go Tried text format, them apostrophe before zip - did n't work Help |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do i keep zip code zeros from disappearing
Give it a custom format of: 00000
(select the cells|Format|cells|number tab|custom and type 00000 in that type box.) If your zip codes could be 5 or 9 digits, you could use a custom format of: [99999]00000-0000;00000 Although I don't know why your previous attempt didn't work. debh wrote: Excel 2003 Have tried formatting the column/cells in special format for zips - no go Tried text format, them apostrophe before zip - did n't work Help -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Essbase: Text zeros to number zeros | Excel Discussion (Misc queries) | |||
| How do I keep leading ZIPcode zeros from disappearing in Excel? | Excel Worksheet Functions | |||
| How do I keep zeros in front of other numbers (like a zip code)? | Excel Discussion (Misc queries) | |||
| when I type a zip code into a cell, only zeros show up. Help? | New Users to Excel | |||
| save text field w/ leading zeros in .csv format & not lose zeros? | Excel Discussion (Misc queries) | |||
Linear Mode
