Thank you all for your help!

"Dave Peterson" wrote:

Try a custom format of
Format|Cells|Number tab|Custom category
[99999]00000-0000;00000

dandiehl wrote:

I am using data validation to ensure the cells in the range are either 5 or 9
digits in length; however, I don't know how to set the formatting of the cell
to recognize whether to use the Zip Code format or the ZIP Code +4 format.

Can I get both?

--

Dave Peterson