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
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
>
Actually if you put 33300 this will enter your last 2 numbers for you.
The # sign omits the Zeros
When you put a Zero in the place you need if you want nothing it puts a zero
Hope this helps,
Michael
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks