Home » Category » Microsoft Excel

Microsoft Excel: zip code format

205| Thu, 22 May 2008 22:16:00 GMT| anonymous| Comments (1)
I need to format a column for zip codes with the same first three numbers.
What is the formula for adding the last two numbers? How do I make it so
when the fourth number is a "0" such as 04?

Thanks

Keywords & Tags: zip, code, format, microsoft, excel

URL: http://www.developertags.com/microsoft-excel/495075/
 
«« Prev - Next »» 1 helpful answers below.
Something like the, maybe.
Format | Cells | Number | Custom:
3330#
This would give you 33301, if you typed 1 into the cell.

tj

"Rachel" wrote:

> I need to format a column for zip codes with the same first three numbers.
> What is the formula for adding the last two numbers? How do I make it so
> when the fourth number is a "0" such as 04?
> Thanks
>

tjtjjtjt | Thu, 22 May 2008 22:17:00 GMT |

Microsoft Excel Hot Answers

Microsoft Excel New questions

Microsoft Excel Related Categories