123-5-30 is text, not a number
If you want to test for whether it would have been a number if you hadn't
put the hyphens in, use the test =ISNUMBER(--(SUBSTITUTE(A1,"-",""))) so
perhaps
=IF(ISNUMBER(--(SUBSTITUTE(A1,"-",""))),"Yes","No")
--
David Biddulph

"Howard" wrote in message
...
I have a bunch of numbers like 123-5-30 and bunch of text in a column. I
want to use a "if" formula that gives me a "Yes" for number and a "No" in
adjacent column. Can you help? I tried it but it sees the numbers as
text
and provides a No for both situation.