Transform the E notation (5.41603241874481E-02 )

[Guest]

Hi
Is there a function, which transform the E notation to a regular number?
I have a function with a double argument. This function demands regular
digits because the double is converted to a text, which is processed. The E
makes the function crash. I have no possibility to change the function so my
only way is to convert E notation numbers to regular numbers. How can I do
this?
Regards
/Niklas

 

[Tom Ogilvy]

A number is a number. E notations is a way it might be displayed. If you
want to convert it to a string for processing, you can use the format
command

Dim dblNum as Double

dblNum = 5.41603241874481E-02
sStr = Format(dblNum,"0.00000000000000000")

msgbox sStr

 

[Guest]

Thanks. It works fine.
Regards
/Niklas

A number is a number. E notations is a way it might be displayed. If you
want to convert it to a string for processing, you can use the format
command

Dim dblNum as Double

dblNum = 5.41603241874481E-02
sStr = Format(dblNum,"0.00000000000000000")

msgbox sStr