krenshala wrote:I was taught (back in the mid to late '70s) that the E (or e) was for Exponent.
MSimon, I just tested it on Open Office. I entered "10e4" into the cell and it changed it to 10000 as the value, and displayed "1.00E+005". I entered "1E4" next, with the result of 1000 as the value and "1.00E+004" being displayed.
I just did the same thing (in OpenOffice), and putting 10e4 into a cell yields 1.00E+005, with a value of 100000. Putting in 1e4 results in 1.00E+004, with a value of 10000.
I think you need to count zeros more carefully.
Last edited by 93143 on Fri Sep 11, 2009 1:47 am, edited 1 time in total.
krenshala wrote:I was taught (back in the mid to late '70s) that the E (or e) was for Exponent.
MSimon, I just tested it on Open Office. I entered "10e4" into the cell and it changed it to 10000 as the value, and displayed "1.00E+005". I entered "1E4" next, with the result of 1000 as the value and "1.00E+004" being displayed.
Personally, I prefer to use 10^n for exponents, but recognize 10En to mean the same thing. Every calculator I've ever used (to include a high-end Hewlett Packard from the early '80s that a friend had, that were so advanced the math teacher didn't recognize it as a calculator) has also supported it.
10000 as the value, and displayed "1.00E+005"
You know. Something doesn't add up here. 10000 <>= "1.00E+5"
I probably mistyped (or misread) something. Its been that kind of day. Checking it again: Entering 10E4; it changed it to 100000 (copied and pasted this time) and displays 1.00E+005. Entering 1e4; it changed it to 10000 and displays 1.00E+004.
Shows what happens when you don't double check that the value you write (type) is the value you read.