is there a way to type 5e5 (as in 5 x 10^5)in numbers now? everytime numbers automatically picks row E5 instead of doing the multiplication.
I know you can type 5 x power(10,1) as well.
MacBook Pro, OS X Mountain Lion (10.8.5)
Just select the cell, then type "5e5" in the cell without the double quotes.
Hi metallicpail,
Use quotes around the scientific format in a formula. For example,
="1e-3"×B2
https://discussions.apple.com/thread/5607442?answerId=23945541022#2394554102223945541
Regards,
Ian.
Wayne, it needs to work in a function, but Yellowbox fixed it, the quations marks work in a function. Thanks!
Ian,
You wrote: Use quotes around the scientific format in a formula.
Just to be clear, the quotes are required in function arguments, but are not generally required in formulas outside of functions.
Jerry
I know you can type 5 x power(10,1) as well.
This statement made me believe you specifically DID NOT want to use a formula a statement preceeded by an "="
OK sorry I should have specified. I mean that in long equations like polynomials i don't want to type =5.4x 1x10^5 +4 x 10^4 .. but rather =5.4e5+4e4 etc., it is in my opinion a bug by apple that they don't regonize the e5 but change it to column E5. However the answer Yellowbox provided with the quatation marks is a suitable fix until apple fixes it.
Hi metallicpail,
It may be a bug. But keep going with the quotation marks. 🙂
Regards, and Happy Numbers!
Ian.
I got it now.
if you try to type:
=5e5*A2
you will see this:
exponents
