Can I fix the exponent in scientific/engineering format?

M

MrShorty

This is sort of a continuation of my search to find a ppm number forma
(http://www.excelforum.com/showthread.php?t=368806).

Found someone who mentioned using engineering formats (kind of a
extension of scientific format). After a little tinkering, here's wha
I've found (using the values of 7E-3 and 7=-5 as examples):

format 7e-3 displayed 7e-5 displayed
.0E+0 .7E-2 .7E-4
0.0E+0 7.0E-3 7.0E-5 (REGULAR SCIENTIFIC NOTATION)
#0.0E+0 70.0E-4 70.0E-6 (EXPONENTS ARE MULTIPLES OF 2)
##0.0E+0 7.0E-3 70.0E-6 (EXPONENTS ARE MULTIPLES OF 3)
###0.0E+0 70.0E-4 7000.0E-8 (EXPONENTS ARE MULTIPLES OF 4)

and so on. Basically I can choose what the exponent is a multiple of.

Now what I would like to do is be able to pick the exponent explicitly
Using the example values above, I'd like to display (without changin
the underlying value):

:confused: 7.00E-3 0.07E-3

Does anyone know how to make this work, or am I just asking for to
much?
 

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

Can I format numbers using engineering notation in excel? 5
I wish to display numbers in engineering format (exponents * 3). 1
Can I format a number display with a fixed exponent? 2
How can I fix the graph in one page when new texts need to be inserted? 5
How do I set up the percentage correctly in this spreadsheet? 2
loop until empty row and column problem (format cells until the lastrow and column in a report) 4
Smaller Procedures in case procedure 3
Linear dynamic systems and signals by Zoran Gajic 0

Top