zip+4 format
 

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

Hi
use a custom format:
00000-0000

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

--
Regards
Frank Kabel
Frankfurt, Germany

pc-confused wrote:
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

Another option...

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

[99999]00000-0000;00000



pc-confused wrote:

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

--

Dave Peterson