ExcelBanter - zero values

ExcelBanter (https://www.excelbanter.com/)

- Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)

- - zero values (https://www.excelbanter.com/charts-charting-excel/60703-zero-values.html)

booklover

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.

B. R.Ramachandran

zero values

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.

All times are GMT +1. The time now is 11:54 AM.