Thread: zero values

How can I show leading zeroes in zip codes in an Excel spreadsheet? I have
clicked the Tools-Options-View-Show Zeroes but the leading zeroes do not
appear.

Hi,

Select the column (or row) containing the zip codes --> "Format" --> "Cells"
--> click on "Number Tab" and "Special" for "category" --> "Zip Code" for
"Type" --> "OK"

Regards,
B. R. Ramachandran

"booklover" wrote:

> How can I show leading zeroes in zip codes in an Excel spreadsheet? I have
> clicked the Tools-Options-View-Show Zeroes but the leading zeroes do not
> appear.