View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Niklas Niklas is offline
external usenet poster
 
Posts: 15
Default Transform the E notation (5.41603241874481E-02 )

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