more optimising

Should have been IIf, but nevermind the procedures I posted. Realized too late (already logged off) that those had errors. Here's module I'm currently working on with updated procedures (I decided to clean out the previous ones from thread since I updated the module anyway, and so discussion doesn't get sidetracked by those erroneous procedures).

Haven't tested performance of module yet... and I'm still at addition/subtraction, still working on the rest...jst had an hour or so free time... though performance untested, the public procedures are easier to use though since the implementation details are hidden in private procedures.

thank you for the help so far, I have to head for work now. I'll work on this more later.

Im finally home and able to mess with the code you uploaded. if I know all of the strings are already numeric without any decimals couldn't I cut out the FixDecimalNum function and the if then(s) calling for it thereby speeding up the exicution?

it also looks like there is handling of negitive numbers in the Texttonum function but i will try to clean that up as well unless it needs to be there for some reason im not seeing yet.