Posted to microsoft.public.excel.programming

AP[_4_]

external usenet poster

Posts: 3

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Numeric to character	Bob[_16_]	Excel Discussion (Misc queries)	3	December 8th 09 07:52 PM
TO DELETE ONLY NUMERIC VALUES IN A CHARACTER AND NUMERIC CELL IN	ramesh k. goyal - abohar[_2_]	Excel Discussion (Misc queries)	1	October 28th 09 06:50 AM
Numeric values as character in CSV	GKW in GA	Excel Discussion (Misc queries)	3	May 23rd 08 02:16 AM
how do I convert numeric value to its character value ex. 10=Ten	Shreesh Asthana	Excel Worksheet Functions	1	April 25th 08 09:16 AM
Determine if character is text or numeric?	Ed	Excel Programming	2	January 5th 05 11:31 PM

All times are GMT +1. The time now is 07:17 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us