View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Ron Coderre
 
Posts: n/a
Default format cells not to except dashes

Try this:
Using cell A1
Set the numbe format to Special and select Phone Number

Then:
DataData Validation
Allow: Custom
Formula: =ISERROR(FIND("-",A1))

If length is an issue:
Use this validation formula instead:
=AND(LEN(A1)=10,ISERROR(FIND("-",A1)))

Does that give you something to work with?

***********
Regards,
Ron


"kclover" wrote:

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