Microsoft Office VBA - Scientific Notation Question - Am I Blind???

Attachment 174047
I'm writing a function NumberToWords which converts a number to text and ran into an issue. I'm trying to figure out programatically what is the threshold or trigger that makes VBA automatically convert a number into scientific notation format. I have included more code than Ii wanted to but can't see how to shorten it and get you enough information to see what i am doing. The below samples show why I'm asking the question and need to handle scientific notation conversions. I am trying to avoid passing numbers as "text". Am I missing an obvious fix?

?NumberToWords("324356842398732872.205") <-- string delimited processes as expected
Three Two Four Three Five Six Eight Four Two Three Nine Eight Seven Three Two Eight Seven Two Point Two Zero Five

?NumberToWords(324356842398732872.205) <-- Number passed as variant doesn't.
Three Point Two Four Three Five Six Eight Four Two Three Nine Eight Seven Three Three Zero Zero One Seven

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Not a direct answer but you may find the solutions here http://www.contextures.com/excelfilesRon.html#RF0001 on Debrahs's site offer an alternative couple of solutions, one VBA one non VBA

Numbers in Excel are limited to 15 significant digits by the floating point format your computer uses. For more than that, you must pass them as text.