Hmmm... In Excel 2003, under Format/Cells/Number/Special, I see Zip code and
Zip+4. Seems to me they have been there for several versions now <g.

On 3 Oct 2005 07:08:00 -0700, "Dave O" wrote:

You can create a custom format by right-clicking the appropriate cell,
then select Format Cells and select the Number tab along the top.
Select Custom from the list on the left. In the Type: box (which shows
the current format of the cell) type ##### or #####-#### if you want
zip+4 . Click OK and you're done.