AnsweredAssumed Answered

Scientific Notation for large and small numbers

Question asked by jveilleux on Jun 6, 2017
Latest reply on Jun 6, 2017 by jveilleux

I did find a function that returns the scientific notation for a number, but it's in text format.  I've tried converting the text to a number (GetAsNumber) but that returns only the mantissa and ignores the exponent (in the form of E+n).  And when this number is exported-to Excel, for example, again you get only the mantissa so you can't do math with it.  Does anyone have a proper form of the scientific notation that gives the correct appearance and that is a proper number on which to perform math operations?

Outcomes