View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bj bj is offline
external usenet poster
 
Posts: 1,397
Default 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?