Re: indetify 5 digit numbers

[Jimbo Razza]

Re: indetify 5 digit numbers

Hey There

I have a cell that could have text, numbers or a combintation of the two in it.

I need to check the cell and create a condition if it has a 5 digit number in it.

How would I do this?

 

[rae30]

do an if statement, len=5

 

[hsk]

Try ........
=IF(AND(ISNUMBER(A1),A1>9999)=TRUE,"Yes","No")

This will be true for all numbers of 5 or more digits ........
If u want the number to be ONLY 5 digits then

=IF(AND(ISNUMBER(A1),Len(A1)=5)=TRUE,"Yes","No")

 

[Scott Huish]

By 5 digit number, I'm assuming 900.5 would not qualify.

Perhaps:
=IF(AND(TRUNC(N(A1))=A1,LEN(A1)=5),"Yes","No")