Oct 17, 2002 #1 DRex Structural Oct 17, 2002 5 0 0 CA 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?
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?
Oct 17, 2002 4 #2 Lcubed Structural Aug 19, 2002 124 0 0 US Enter data in Engrg notation by using, for example, 12e6 for 12 million. Custom format cells as ##0.0E+0, then any entry will appear in Engrg. notation. Hope this helps. Upvote 0 Downvote
Enter data in Engrg notation by using, for example, 12e6 for 12 million. Custom format cells as ##0.0E+0, then any entry will appear in Engrg. notation. Hope this helps.
May 23, 2003 #3 BobHoltz Electrical May 23, 2003 1 0 0 US I tired using ##0.00E+0 and ##00.00E+0 and I get answers that are wrong: 510/7372800 = 69.17 E-6 Excel tells me 6.91E-6 or 691.7E-8 both wrong. Upvote 0 Downvote
I tired using ##0.00E+0 and ##00.00E+0 and I get answers that are wrong: 510/7372800 = 69.17 E-6 Excel tells me 6.91E-6 or 691.7E-8 both wrong.
May 23, 2003 #4 Mutt Chemical Mar 7, 2003 96 0 0 ZA Finger trouble perhaps? Lcubed's answer is correct! Upvote 0 Downvote
May 23, 2003 #5 IRstuff Aerospace Jun 3, 2002 44,355 4 38 US seems to work correctly here: 510/7372800 69.2E-6 TTFN Upvote 0 Downvote