lead zeroes in zip codes

  • Thread starter Thread starter fred rosenfeld
  • Start date Start date
F

fred rosenfeld

How do you do a spread sheet and maintain a lead zero in
the zipcode (example 08550 shows up as 8550)?
 
fred rosenfeld said:
How do you do a spread sheet and maintain a lead zero in
the zipcode (example 08550 shows up as 8550)?
Click to expand...

Format the cell with a custom format 00000 and you will always see 5 digits.
 
Hi Fred!

In addition to Anon's 00000 custom format suggestion, there's also two
Zip code formats under Format > Cells > Number > Special. Plain
vanilla "Zip Code" and "Zip Code + 4"

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
Holidays and Observances Thursday 31st July: Bermuda (Cup Match Day),
Congo (Upswing of the Revolution), Mexico (Day of Mourning), Peru (San
Ignacio). Observances: Lunasa / Lammas (Pagan N. Hemisphere), Oimelc /
Brigid (Pagan S. Hemisphere)
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
A custom format for the zipcodes might be easier to apply if you have a mixture
of both styles:

[<100000]00000;00000-0000
(courtesy of Ron Rosenfeld)
 
Back
Top