Excel ISNUMBER Function with IF Statement

Question

I have an Excel file I'm working with. There is a column that contains numbers and text, sometimes it's just one or the other. I'm trying to write a function that scans the left most part of the cell to see if it starts with a number. I thought I had it but apparently not. This is what I had:

=IF(ISNUMBER(LEFT(E8,1)), "True", "False")

This continues to throw me a "false" result even though that particular cell, E8, begins with a "3". What am I missing here?

Answer 1

Try this out:

=IF(ISNUMBER(VALUE(LEFT(E8,1))),"True","False")