View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson[_3_] Jim Thomlinson[_3_] is offline
external usenet poster
 
Posts: 983
Default limited value in a cell ?

When I need phone numbers I use two things. Custom formats and validation.
Use validation to restrict the user to entering integers between cretain
numbers. in your case: 10000000000 and 99999999999. Now to display the number
correctly use a custom format. Choose format cell - custom - now enter (##)
###-###-###

HTH

"Tomek" wrote:

Hello!

Is there any way to limit the value we write in a cell.
For example: I would like to write only phone numbers in one column of
such structure (12) 111-111-111. Of course the are many different
numbers.
I would like to limit it that nobody could write there letters or other
signs or more numbers than is in the structure.

for example:
(48) 121-121-252 correct
(52) 1233-14-254 not correct
(52)52-22-55555 not correct
(56) adc-455-222 not correct
(00) 000-012-987 correct

Thank you very much for help.
Tomek
--
Tomek