Continue to Site

Welcome to EDAboard.com

Welcome to our site! EDAboard.com is an international Electronics Discussion Forum focused on EDA software, circuits, schematics, books, theory, papers, asic, pld, 8051, DSP, Network, RF, Analog Design, PCB, Service Manuals... and a whole lot more! To participate you need to register. Registration is free. Click here to register now.

Excel - Engineering format

Status
Not open for further replies.

Hot Wire

Newbie level 4
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.

Part and Inventory Search

Welcome to EDABoard.com

Sponsor

Back
Top