| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#8
|
|||
|
|||
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Returning left part of cell before a character | Excel Discussion (Misc queries) | |||
| Get characters on left of specified character in Excel | Excel Discussion (Misc queries) | |||
| Limit character count in cell from left | Excel Discussion (Misc queries) | |||
| How to edit column data so that all but left most character remain | Excel Discussion (Misc queries) | |||
| Test for Single Character That is in an Array | Excel Worksheet Functions | |||
Linear Mode
