Test left character is a number?

[Guest]

hi, have formula for whole cell to equal a number, but is it possible to test
only the left character to be a number. thanks.

have: =ISNUMBER(AD9)

sample of data: 1F

 

[T. Valko]

Try this:

=ISNUMBER(--LEFT(A1))

 

[Dave Peterson]

or even
=isnumber(-left(a1))

<vbg>

Try this:

=ISNUMBER(--LEFT(A1))

 

[Guest]

=LEFT(A1)*1>=0

 

[Guest]

thanks..

or even
=isnumber(-left(a1))

<vbg>

 

[Rick Rothstein \(MVP - VB\)]

Won't that generate an error if the first character is not a digit?

Rick

 

[Guest]

You are correct. It generate an error when it's not a number. If it's a
number then it returns TRUE. Instead return TRUE/FALSE, my is return
TRUE/#VALUE!