Engineering Notation in Excel ?
Engineering Notation in Excel ?
(OP)
Most calculators have an Engineering notation feature which formats output in Scientific Notation with the 10 power restricted to multiples of 3.
eg. 534.0x10^3 rather than 5.340x10^5
Does anyone know how to do this in Excel?
eg. 534.0x10^3 rather than 5.340x10^5
Does anyone know how to do this in Excel?





RE: Engineering Notation in Excel ?
RE: Engineering Notation in Excel ?
510/7372800 = 69.17 E-6
Excel tells me 6.91E-6 or 691.7E-8 both wrong.
RE: Engineering Notation in Excel ?
RE: Engineering Notation in Excel ?
510/7372800 69.2E-6
TTFN