Re: Scientific E notation: How to get it

2013-09-23 Thread Monte Goulding
On 23/09/2013, at 8:39 PM, "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' --> 1.23E-06

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 "

Re: Scientific E notation: How to get it

2013-09-23 Thread Monte Goulding
On 23/09/2013, at 7:32 PM, Monte Goulding 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 development services mer

Re: Scientific E notation: How to get it

2013-09-23 Thread Monte Goulding
On 23/09/2013, at 7:06 PM, "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! ___

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. Norma