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

Your method is one of the "safest" methods.

Someone may suggest a more "standard" method of using "Isnumeric", for
example:

Isnumeric("1")

However, this is not always "safe", especially in older versions of Excel
(e.g. Excel 5 and 97) Therefore, to test single characters, it's not worth
taking the risk. So, I think using the ASC test is more safe.

Regards,
Edwin Tam
[email protected]
http://www.vonixx.com



"AP" wrote:

> 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
>
>

AP,
If you wish to be pedantic, what does "½" or "?" mean to you ?

Nick


"AP" <[email protected]> wrote in message
news:[email protected]...
> 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
>