Excel function ISNUMBER with IF expression

Question

I have an Excel file I'm working with. There is a column that contains numbers and text, sometimes it is one or the other. I am trying to write a function that scans most of a 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 give me a “false” result, although this particular cell of E8 starts with “3”. What am I missing here?

Answer 1

Try the following:

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

Answer 2

Please note that you can achieve what you need only with the following:

=NOT(ISERROR(LEFT(E8)*1))

LEFT(E8) LEFT(E8,1) 1 -

, , :

IF(NOT(ISERROR(LEFT(E8)*1)),"True","False")

ISNUMBER() NOT(ISERROR())

=ISNUMBER(LEFT(A1)*1)
=IF(ISNUMBER(LEFT(A1)*1),"True","False")

Answer 3

=IFERROR(IF(VALUE(LEFT(E8,1)),"TRUE","FALSE"),"FALSE")

Answer 4

Using the IF statement is redundant. The easiest and most effective way to achieve the desired result:

=ISNUMBER(--LEFT(E8,1))

It will automatically return TRUE or FALSE