I like David's answer but here is another
=IF(ISNUMBER(--LEFT(A1,2)),"Yes","No")
will test if the first two charters in tour text an digits - you can alter
the 2 as needed
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"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.