Non-VBA solution

=AND(ISNUMBER(A1),LEN(A1)=9) entered in B1 and double-clicked to copy down.

Will return true or false.


Gord Dibben MS Excel MVP

On Tue, 4 Mar 2008 11:48:21 -0800 (PST), wrote:

In a single column, I need to be able to find all nine-digit numbers.
All the numbers are different, but they all have nine digits. It seems
like I could do this in Word, but I can't figure out how to do it in
Excel.

Thanks!