Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Determine if a character is numeric or non-numeric
Is there a more efficient way to determine if a single character is a
number versus a non-number? I use the ASC() function to check for the ASCII values between 48-57? Thanks in advance |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Determine if a character is numeric or non-numeric
Grüezi AP
AP schrieb am 10.05.2005 Is there a more efficient way to determine if a single character is a number versus a non-number? I use the ASC() function to check for the ASCII values between 48-57? Maybe the functon IsNumeric(): IsNumeric(Var1) Mit freundlichen Grüssen Thomas Ramel -- - MVP für Microsoft-Excel - [Win XP Pro SP-2 / xl2000 SP-3] |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Determine if a character is numeric or non-numeric
Thanks, I new there was an easier way!
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Numeric to character | Excel Discussion (Misc queries) | |||
TO DELETE ONLY NUMERIC VALUES IN A CHARACTER AND NUMERIC CELL IN | Excel Discussion (Misc queries) | |||
how do I convert numeric value to its character value ex. 10=Ten | Excel Worksheet Functions | |||
Determine if a character is numeric or non-numeric | Excel Programming | |||
Determine if character is text or numeric? | Excel Programming |