View Single Post
  #13   Report Post  
Posted to microsoft.public.excel.misc
pallaver pallaver is offline
external usenet poster
 
Posts: 62
Default Finding Number Inside a Cell

Hehe... don't worry about it JLatham. I already added that in !!! I
realized it was deleting it so took a guess and got it.


On 7¤ë15¤é, ¤È«á8:12, JLatham <HelpFrom @ Jlathamsite.com.(removethis)
wrote:
NEEDS A CORRECTION.
After reading one of your posts, I realize that the constant
numericCharacters needs to have the decimal point added to it. If you try
that code out, change that line to read:
Const numericCharacters = "0123456789+-."
The change in the sequence of characters in it will probably improve
performance just a tiny bit since the probability of encountering a digit is
higher than one of the +, - or . symbols.