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