I wish to display numbers in engineering format (exponents * 3).

G

Guest

Just as some engineering calculators display number calculations using
exponents that are multiples of 3, I would like to do the same in Excel. Then
numbers come out a micro, nano, kilo, etc.


----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...c-bbe97234de7a&dg=microsoft.public.excel.misc
 
J

JE McGimpsey

You can display numbers in Engineering notation now:

Format/Cells/Number/Custom ##0.###E+00
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

INSERT 3 ROWS WHEN DATA OF COLUM CHANGED 2
Can I fix the exponent in scientific/engineering format? 1
please, add the feature that allows us to attach file with our thr 3
Calculating Incremental Percentages 2
distinct count summarize Data for pivoit table 1
How do a import data from a text file to an excel worksheet 4
EXCEL FUNCTIONS 1
Restore superscript and subscript buttons in Excel toolbars 1

Top