Home » Category » Microsoft Excel

Microsoft Excel: zip+4 format

205| Wed, 04 Jun 2008 19:25:00 GMT| anonymous| Comments (2)
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

Keywords & Tags: zip+4, format, microsoft, excel

URL: http://www.developertags.com/microsoft-excel/495135/
 
«« Prev - Next »» 2 helpful answers below.
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

frank | Wed, 04 Jun 2008 19:26:00 GMT |

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

dave | Wed, 04 Jun 2008 19:27:00 GMT |

Microsoft Excel Hot Answers

Microsoft Excel New questions

Microsoft Excel Related Categories