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

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]

Determine if a character is numeric or non-numeric
 

Thanks, I new there was an easier way!