nine digits
try this
in adjacent cell of phone number put this formula
=IF(LEN(A1)<9,"less or more than 9 digit","")
or
use conditional format
select the range where u have phone number then
go to | format | conditonal format | condition1 : formula is =LEN(A1)
<9 | format | choose a color | ok | ok
On Jan 28, 1:02*pm, Omar wrote:
Dear Experts,
I have one column represents customer’s phone numbers in the following
format 045735403, 04 is the key and the rest is the line number.
How can I know if the number contains nine digits only, not more not
less?
Many thanks in advance
Omar
|