View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
clara clara is offline
external usenet poster
 
Posts: 252
Default Format Tel Number

Hi all,

I format a cell with (###)###-#### in order to display a telephone number in
(555)666-7777 way. I want use conditional format to give users warning in
the following two cases:
1.containg letter
2.number of digits is not equal 10

How can I do it?

thank you very much

Clara