View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Transform the E notation (5.41603241874481E-02 )

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