Engineering Notation, Again

[jqavins]

I've searched for how to do engineering notation, and found the same answer in several places (multiple threads here and on other sites) but that answer isn't correct. Formats such as ##0.0E+0 give a fixed number of decimal places in the mantissa, but proper engineering notation adjusts the number of decimal places to keep the number of signicant figures constant. See examples below.

Number​	##0.3E+0​	Engineering Notation (three digits)​
pi()*10^6	3.1E+6	3.14E+6
pi()*10^5	314.2E+3	314E+3
pi()*10^4	31.4E+3	31.4E+3
pi()10^3	3.1E+3	3.14E+3
pi*10^-4	314.2E-6	314E-6

<tbody>
</tbody>

See the difference? In regular scientific notation there are always the same number of significant digits, one before the decimal and as specified after. Engineering notation is also supposed to have a constant number of significant digits.

So can anyone think of a way to do it right?

 

[SpillerBD]

Scientific Notation <> Engineering Notation.
Despite how close they are, the small differences are significant