Upgraded to El CRapitan (wish I hadn't! Nothing works properly anymore grrr)
Numbers updated to new version. (more complicated than taking an exam for NASA)
Now a spreadsheet I was working on has changed. (Not a happy bunny!)
Q .How do i change a cell / formula to calculate an answer to just TWO decimal places as it was originally?
Thanks!
Georgie
iMac, OS X El Capitan (10.11)
select the cells with the Numbers to format, you can make one large selection if you want, then open the Cell Formatter:
Now select "Number" from the "Data Format" pop-up menu, then set the number of decimal places to "2":
select the cells with the Numbers to format, you can make one large selection if you want, then open the Cell Formatter:
Now select "Number" from the "Data Format" pop-up menu, then set the number of decimal places to "2":
How do i change a cell / formula to calculate an answer to just TWO decimal places as it was originally?
Wayne's solution just shows two decimals, it will not calculate to just two decimals.
If you take 3.122 and apply the solution above, it will display 3.12 If you then Multiply that by 10 and it will show 31.22
It will show 3.13 if your number was 3.125, rounding it.
Do you want to display two or calculate to two?
We can provide more info on how to get only two significant decimals. (TRUNC, FLOOR, CEILING, ROUND are all function related to this)
Thanks
Jason
Thank you so much for posting this - really helped me out.
Numbers for Mac: Change to 2 Decimal Places
