But if you do want Engineering notation you would use
##0.0E+0
for the format.

see http://www.mvps.org/dmcritchie/excel/formula.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Dave Peterson" wrote in message ...
A search of Google showed this:

In scientific notation, the numeric part must be at least 1.0 and less
than 10.0, and the exponent can be any integer.

In engineering notation, on the other hand, the exponent must be a
multiple of 3. To accommodate this extra restriction on the exponent,
the numeric part has more freedom: it must be at least 1.0 and less
than 1000.0. That is, you can have 1 to 3 digits to the left of the
decimal point.

http://mathforum.org/library/drmath/view/55606.html

Just for the pedants out there!


Dave Peterson wrote:

E-007 is engineering notation (or scientific notation??).

It means to take that first number (3.123423 in your sample) and multiply it by
10^-7 (and 10 raised to a negative 7 means to divide (this time by 1000000).

So your sample is a very small number: 0.0000003123423

7E5 = 7*(10^5) = 7*100,000 = 700,000

3E-2 = 3*(10^-2) = 3*(1/100) = 3/100 = .03

You can play around with this by changing the format
format|cells|number tab|Number category
Show as many decimals as you need--you can see it in the sample box.

L.C. wrote:

Hi sometimes when computing my results i get a number that looks like
"3.123423e-007" in my cell.
what does the "e-007" mean?

--

Dave Peterson

--

Dave Peterson