Scientific E notation: How to get it

[FlexibleLearning.com]

Thank you, Monte, but the numberFormat of the output is somewhat
non-standard...

    put format("%E",0.000001234) --> 1.234000E-006

Can this syntax include alternative numberformats?

For example:
    '0.00' --> 1.23E-06
    '0.###' --> 1.234E-06
    '00.0000' --> 01.2340E-06

Just asking as my "%E" syntax skills are sadly lacking!

Hugh Senior
FLCo


> On 23/09/2013, at 7:32 PM, Monte Goulding
> <monte at sweattechnologies.com> wrote:
>
> >> If you have a shorter alternative or find any glitches, please post!
> >
> >
> > put format("%e",0.000001)
>
>
> Oops... I see you wanted uppercase E:
> put format("%E",0.000001)
>
> ;-)
>
> --
> Monte Goulding
>
> M E R Goulding - software development services
> mergExt - There's an external for that!
> *********************************************