| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I keep leading ZIPcode zeros from disappearing in Excel?
When preparing an Excel document for sort-merge mailing of our Xmas cards the leading zero in ZIPcodes disappears. How do I keep leading ZIPcode zeros from disappearing in Excel? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I keep leading ZIPcode zeros from disappearing in Excel?
try <format<number<special<Zipcode
"Krabapple" wrote: When preparing an Excel document for sort-merge mailing of our Xmas cards the leading zero in ZIPcodes disappears. How do I keep leading ZIPcode zeros from disappearing in Excel? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I keep leading ZIPcode zeros from disappearing in Excel?
Pre-format the cells as text before entering the numbers or precede each zip
code with an apostrophe. Gord Dibben MS Excel MVP On Thu, 7 Dec 2006 13:07:01 -0800, Krabapple wrote: When preparing an Excel document for sort-merge mailing of our Xmas cards the leading zero in ZIPcodes disappears. How do I keep leading ZIPcode zeros from disappearing in Excel? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
| How do I enter NUMBERS with leading zeros In Excel ie 001, 002 ? | Excel Discussion (Misc queries) | |||
| I want to keep leading zeros in my excel spreat sheet, How? | Excel Discussion (Misc queries) | |||
| How do I get Excel not to erase a leading Zipcode zero (eg 0xxxx) | Excel Discussion (Misc queries) | |||
| Leading Zeros | Excel Discussion (Misc queries) | |||
Linear Mode
