How do I keep leading ZIPcode zeros from disappearing in Excel?

**Krabapple** · December 7th 06, 09:07 PM posted to microsoft.public.excel.worksheet.functions

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?

bj · December 7th 06, 09:17 PM posted to microsoft.public.excel.worksheet.functions

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?

**Gord Dibben** · December 7th 06, 09:36 PM posted to microsoft.public.excel.worksheet.functions

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?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do I enter NUMBERS with leading zeros In Excel ie 001, 002 ?	bobl3517	Excel Discussion (Misc queries)	5	August 29th 06 02:57 PM
I want to keep leading zeros in my excel spreat sheet, How?	Mark Engbretsen	Excel Discussion (Misc queries)	3	August 10th 06 02:54 AM
Stop excel from dropping the 0 in the beginning of a number?	Rosewood	Setting up and Configuration of Excel	11	February 12th 06 01:38 AM
How do I get Excel not to erase a leading Zipcode zero (eg 0xxxx)	Ted W.	Excel Discussion (Misc queries)	1	January 18th 06 08:28 PM
Leading Zeros	Karen	Excel Discussion (Misc queries)	3	January 10th 06 09:50 PM