zip+4 format

[Guest]

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

 

[Frank Kabel]

Hi
use a custom format:
00000-0000

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

 

[Dave Peterson]

Another option...

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

[>99999]00000-0000;00000