ELATHAM
How do I keep Excel from Rounding off. When it rounds off it makes my final totals wrong.
My figures need to balance right to the penny.
Thank you,
Estrella
![]() |
ELATHAM
How do I keep Excel from Rounding off. When it rounds off it makes my final totals wrong.
My figures need to balance right to the penny.
Thank you,
Estrella
Are you formatting the cells for a specific number of decimal places or as currency? Normally Excel doesn't round the value that's in the cell, unless you use the Round function. However, if you format the cell to display a limited number of decimal places, it will round the display but toals will be correct. For example you have these three numbers and their 2 decimal display:
12.3478 12.35
15.1232 15.12
17.6759 17.68
However, they would total to 45.1469 which would display as 45.15.
All times are GMT -7. The time now is 03:46 AM. |