View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JE McGimpsey
 
Posts: n/a
Default format cells not to except dashes

Format is a display function only, it doesn't affect how entries are
parsed (I assume you mean "accept").

You can use validation. Select your range (I'll assume that A1 is the
active cell). Choose Data/Validation/Allow:Custom with the formula

=ISERR(FIND("-",A1))



In article ,
"kclover" wrote:

I am trying to format a range of cells not to except dashes (-) ie. when
entering phone numbers 123-123-1234