Excel - Engineering format

Status
Not open for further replies.
H

Hot Wire

Newbie level 4
Joined
Jan 7, 2007
Messages
6
Helped
0
Reputation
0
Reaction score
0
Trophy points
1,281
Activity points
1,331
excel engineering notation

I would like to format numbers in excel in an engineering way.
That is, I would like to display numbers as follows 12e03 or 100.3e06 or 48e-9. Does anybody know how to do this?
 

excel engineering format

go to format....
in the number tab ....
select the Scintific ....
and set the decimal plasec on 2 or other

(maybe it helps you)
 

engineering format in excel

at the format menu

Format Cells

Category : Custom

Here is the format string for engineering notation

##0.00E+00

You can also put in strings in quotes there to label thing.

Dave
www.keystoneradio.com
 
excel format engineering

Hot Wire,
Use this format string:
.
###.000E+00
.
For more info on formatting, se
pubs.logicalexpressions.com/pub0009/LPMArticle.asp?ID=414
Regards,
Kral
 
Status
Not open for further replies.

Similar threads

Menu
Log in
Register
Cookies are required to use this site. You must accept them to continue using the site. Learn more…