View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips
 
Posts: n/a
Default 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