Phone Number Validation 2

[zoe19]

I am adding Phone numbers into a worksheet in Excel 2000 and I am trying to validate entries which will only
accept numbers beginning with 01

e.g 0151 123 3456 this is the format I want to customize
I have tried Excels own phone number Validation but it gets rid of the 0 at the front of the number.

Is there a way of validating numbers

Zoe

 

[GlennUK]

Firstly, have the column formatted at text, so that if anyone enters all numeric phone numbers they won't be taken to be real numbers.

Do Data Validation on the column, with a Custom Validation of
=LEFT(A1,2)="01"
assuming you have column A selected ( with cell A1 and the active cell ).

That should do it.

Cheers, Glenn.

 

[DeLaMartre]

Good one, Glenn!

Thanks,

-Bob in California