I had to tweak it a bit to this:
=IF(LEN(A1)=5,A1&"-0000",A1) becasue if the existing number was already in
the zip + 4 format, it would return "FALSE".

However, this formula does not work on zip codes that start with a zero
(mostly New England areas). 01804 doesn't get "converted" because its length
is seen as less than 5.

Any ideas of how to get around that quirk?

Jerry

"Bearacade" wrote:


Did you try the

=IF(LEN(A1)=5,A1&"-0000")

This will add -0000 to cells that doesn't have +4s


--
Bearacade


------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=557123