Thread: Determine if a character is numeric or non-numeric
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Thomas Ramel Thomas Ramel is offline
external usenet poster
  
Posts: 70
Default 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]
Reply With QuoteReply With Quote