zip code format
 

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

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