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)
To add to the talking to oneself:
The space between the D and 2 for the last D2 in the equation will cause an error. Remove it and the formula should work.
Setup the calculations similar in the other cells and you should get the engineering format.
Nope. Needs more work. However, it does work in some instances.
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.
how can I set up engineering notation in numbers '09?
