zip code format

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

format cells as zip code not working 3
Zip Code formatting problem 3
Turning a 9 digit string into zip+4 3
Format appears stuck..how to break formatting 2
changing zip code to number 3
How do I make a vertical report export into a vertical report? 3
VLOOKUP formula? 12
Adding a HYPHEN to a 9 digit zip code column 7

Back
Top