Formatting an exponential number

[pfavazza1]

Hi,

My DAQ returns a number of 1.818123E-5.  I want to format that number to the display and a spreadsheet to 18.18123E-6.

Thanks

Peter Favazza

[paul_cardinale]

Programming -> String -> Number/String Conversion -> Number to Engineering String

or 

%^g

[wiebe@CARYA]

The spreadsheet (Excel?) might decide itself how it displays values. So even if you write it to file correctly it might not show as you'd like. That would also depend on the file format you're writing, and if you use the report generation toolkit, whether you're writing numbers or strings.