Thread: formatting a cell for both ZIP and ZIP+4
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
dandiehl dandiehl is offline
external usenet poster
  
Posts: 12
Default formatting a cell for both ZIP and ZIP+4
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?
Reply With QuoteReply With Quote