engineering exponents

[Pete]

In Excel is there a way to express exponents in
engineering notation:
x.xxE+06
x.xxE+03
x.xxE+00
x.xxE-03
x.xxE-06
x.xxE-09
x.xxE-12
etc.
Thanks

 

[JulieD]

Hi Pete,

if i'm understanding you correctly, what you need to do is right mouse click
on the cells, choose format cells / numbers tab - click on scientific and i
think you'll get what you're looking for.

Regards
JulieD

 

[Pete]

Hi JulieD
In engineering notation the exponent is always a multiple
of 3.
Any idea how to do that?

 

[JulieD]

Hi Pete

sorry, can't help - maybe someone else can ...

Cheers
JulieD

 

[Juan Pablo González]

Try this:

http://www.stfx.ca/people/bliengme/ExcelTips/EngineeringNotation.htm

 

[Pete]

Thanks!

-----Original Message-----
Try this:

http://www.stfx.ca/people/bliengme/ExcelTips/EngineeringNo tation.htm

--
Regards

Juan Pablo González




.