Test left character is a number?
 

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

Test left character is a number?
 

Try this:

=ISNUMBER(--LEFT(A1))

--
Biff
Microsoft Excel MVP


"nastech" wrote in message
...
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

Test left character is a number?
 

or even
=isnumber(-left(a1))

<vbg

"T. Valko" wrote:

Try this:

=ISNUMBER(--LEFT(A1))

--
Biff
Microsoft Excel MVP

"nastech" wrote in message
...
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

--

Dave Peterson

Test left character is a number?
 

=LEFT(A1)*1=0

"nastech" wrote:

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

Test left character is a number?
 

thanks..

"Dave Peterson" wrote:

or even
=isnumber(-left(a1))

<vbg

"T. Valko" wrote:

Try this:

=ISNUMBER(--LEFT(A1))

--
Biff
Microsoft Excel MVP

"nastech" wrote in message
...
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

--

Dave Peterson

Test left character is a number?
 

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

Rick


"Teethless mama" wrote in message
...
=LEFT(A1)*1=0

"nastech" wrote:

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

Test left character is a number?
 

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!


"Rick Rothstein (MVP - VB)" wrote:

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

Rick


"Teethless mama" wrote in message
...
=LEFT(A1)*1=0

"nastech" wrote:

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

I know I'm raising a dead post back to life, but it's one of those useful answers

From Stackoverflow
ISNUMBER(--LEFT(B2,1))

also works with mid (and presumably right)

bc --LEFT(b2,1) returns #value and isnumber takes that to be non-numeric.