Scientific E notation: How to get it

2013-09-23 Thread FlexibleLearning.com
I needed to convert decimals to E notation and as it took me a while, I thought it might be useful to others. If you have a shorter alternative or find any glitches, please post! on mouseUp put fld in into tNum put fld NumberFormat into tNumberFormat --| to specify output precision. Normally

Re: Scientific E notation: How to get it

2013-09-23 Thread Monte Goulding
On 23/09/2013, at 7:06 PM, FlexibleLearning.com ad...@flexiblelearning.com wrote: If you have a shorter alternative or find any glitches, please post! put format(%e,0.01) -- Monte Goulding M E R Goulding - software development services mergExt - There's an external for that!

Re: Scientific E notation: How to get it

2013-09-23 Thread Monte Goulding
On 23/09/2013, at 7:32 PM, Monte Goulding mo...@sweattechnologies.com wrote: If you have a shorter alternative or find any glitches, please post! put format(%e,0.01) Oops... I see you wanted uppercase E: put format(%E,0.01) ;-) -- Monte Goulding M E R Goulding - software

Re: Scientific E notation: How to get it

2013-09-23 Thread FlexibleLearning.com
Thank you, Monte, but the numberFormat of the output is somewhat non-standard... put format(%E,0.01234) -- 1.234000E-006 Can this syntax include alternative numberformats? For example: '0.00' -- 1.23E-06 '0.###' -- 1.234E-06 '00.' -- 01.2340E-06 Just asking as my %E

Re: Scientific E notation: How to get it

2013-09-23 Thread Monte Goulding
On 23/09/2013, at 8:39 PM, FlexibleLearning.com ad...@flexiblelearning.com wrote: Thank you, Monte, but the numberFormat of the output is somewhat non-standard... put format(%E,0.01234) -- 1.234000E-006 Can this syntax include alternative numberformats? For example: '0.00'