You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
I am taking some electronics courses in college and need to be able to use engineering notation ie: 1E-3, 9E6, etc. How can I best set this up in Numbers '09? All of my entries are automatically being formated as scientific notation (not multiples of 3) and the only other option I can find is just standard numbers. Thank you for your assistance.
Numbers '09-OTHER, Mac OS X (10.7.3)
My solution will be like this. ( checked on Numbers 3.6.2 )
B := LOG10( ABS( A ) )
just to simplify the formula for C
C := IF( B ≥ 0, FLOOR( B , 3 ), CEILING( B, −3 ) )
with special cell format for leading 0 and plus sign
D := FIXED( A ÷ (10^C) , 2 ) & "E" & C
0
I also tested LibreOffice 5.1.5.2 ( latest stable ), which supports Excel like cell format option ( ##0.00E+00 ), however the format is not transferred to Numbers even if the spreadsheet is saved as Excel's.
In excel, with that format you get scientific notation, but in which the exponent is a multiple of three, which is what is intended (I think)
Nope. Needs more work.
Ian.
Nope. Needs more work. However, it does work in some instances.
how can I set up engineering notation in numbers '09?
