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

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

--
Regards,
Tom Ogilvy






"Niklas" wrote in message
...
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

Thanks. It works fine.
Regards
/Niklas

"Tom Ogilvy" wrote:

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

--
Regards,
Tom Ogilvy






"Niklas" wrote in message
...
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