How do I stop dollar figures from rounding up - and keeping decimal points?
How do I stop dollar figures from rounding up - and keeping decimal points?
iMac with Retina 5K display, OS X Yosemite (10.10.2)
How do I stop dollar figures from rounding up - and keeping decimal points?
iMac with Retina 5K display, OS X Yosemite (10.10.2)
Hi Kelly,
Please give an example of your calculations and the rounding. A screen shot of a small part of a table often helps.
Regards,
Ian.
select the cells with the dollar amounts, then open the cell formatter and select "Currency"
Now set the number of decimal places. Note... Numbers will round to the number of digits you select so you should know that what you see in the cell may be different that what you typed into the cell.
If you set the number of digits in the cell formatter to 3, then type in a value "1.2368", Numbers will display "1.237"
Many thanks Wayne. Awesome!
Kelly
How do I stop dollar figures from rounding up - and keeping decimal points?