F
fred rosenfeld
How do you do a spread sheet and maintain a lead zero in
the zipcode (example 08550 shows up as 8550)?
the zipcode (example 08550 shows up as 8550)?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
Anon
fred rosenfeld said:How do you do a spread sheet and maintain a lead zero in
the zipcode (example 08550 shows up as 8550)?
Format the cell with a custom format 00000 and you will always see 5 digits.
N
Norman Harker
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)
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
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)
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
D
Dave Peterson
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)
of both styles:
[<100000]00000;00000-0000
(courtesy of Ron Rosenfeld)