ExcelBanter - I am not able to format cells for zip codes

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - I am not able to format cells for zip codes (https://www.excelbanter.com/excel-worksheet-functions/7847-i-am-not-able-format-cells-zip-codes.html)

JMelloman

I am not able to format cells for zip codes

The first number of zip codes ("0") does not display in cells. I Have tried
to format cells for zip codes but this still does not help.

Jason Morin

Try a custom format of 00000 .

HTH
Jason
Atlanta, GA

-----Original Message-----
The first number of zip codes ("0") does not display in
cells. I Have tried
to format cells for zip codes but this still does not
help.
.

Frank Kabel

Hi
use a custom format such as:
00000

"JMelloman" wrote:

The first number of zip codes ("0") does not display in cells. I Have tried
to format cells for zip codes but this still does not help.

Dave Peterson

Maybe you could use a custom format to cover both 5 digits and 9 digit zips:

[99999]00000-0000;00000

JMelloman wrote:

The first number of zip codes ("0") does not display in cells. I Have tried
to format cells for zip codes but this still does not help.

--

Dave Peterson

All times are GMT +1. The time now is 10:52 AM.