Thread: Finding cells with numbers
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
David
 
Posts: n/a
Default Finding cells with numbers
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
Reply With QuoteReply With Quote