Posted to microsoft.public.excel.programming

Niklas

external usenet poster

Posts: 15

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How I transform a row into a column?	Mosqui	Excel Discussion (Misc queries)	0	January 19th 07 08:30 PM
How I transform a row into a column?	Stefi	Excel Discussion (Misc queries)	0	January 19th 07 08:22 PM
Table Transform	James	Excel Discussion (Misc queries)	3	December 5th 06 07:57 PM
Transform.	TOM	Excel Programming	9	May 21st 04 05:14 AM
Transform columns with VBA	Michael E.	Excel Programming	5	May 1st 04 05:57 PM

All times are GMT +1. The time now is 01:20 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us