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