Validation checks

[stiffrimpet]

When putting validation checks on cells, is there a way of specifying a certain number of digits (for example, for a phone number)?

Cheers

s=t=i=f=f=r=i=m=p=e=t

 

[Brian from Maui]

On 2002-04-14 07:00, stiffrimpet wrote:
When putting validation checks on cells, is there a way of specifying a certain number of digits (for example, for a phone number)?

Cheers

s=t=i=f=f=r=i=m=p=e=t

Try text length

 

[Legacy 98055]

To add a bit more detail to Brian's reply...
We are assuming that you are using 'Data Validation'?
If so, you will notice a combobox with the label 'Allow'.
One of the options which you can allow is 'Text Length'.
You may set a minimum or maximum for data entered...
However, this setting will not differentiate between numbers and text strings.
There are other ways of forcing exact masks of data entry if you need them directly in your cells or in a form.
There also may be other ways which I am not aware of.
Tom