formatting a cell for both ZIP and ZIP+4
Post the formulas you're using to ensure a 5 or 9 digit entry.
--
Regards,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"dandiehl" wrote in message
...
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?
|