zip+4 format

P

pc-confused

What formula do i use to enter zipcode as 9 numbers and get back in 5-4 format?
Example: enter 77773333 see in cell 77777-3333
 
F

Frank Kabel

Hi
use a custom format:
00000-0000

or to return a string with a formula try:
=TEXT(A1,"00000-0000")
 
D

Dave Peterson

Another option...

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

[>99999]00000-0000;00000
 
Top