Finding cells with numbers
=ISNUMBER(--LEFT(A1,1))
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"David" wrote in message
...
Bob Phillips wrote
=IF(ISNUMBER(A1),A1,FALSE)
OP said:
I want to be able to make this work if any number 0-9 is the first
character in the cell,
--
David
|