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?

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?

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?