Forum Discussion
Removing decimal data from a draft budget
I've created a draft budget and decided not to display the pennies for simplicity of appearance. I went to the Currency formatting and reduced the decimal display from 2 places to zero but it doesn'...
Lee_Jackson76 formatting doesn't change the underlying data. You have to enter data without decimals or use the ROUND function to round all calculations to zero decimals. For instance,
=ROUND(A1 * 10.5%, 0)
Thanks. I tried that and nothing happened, so I guess I would have had to set that rounding formula before I entered all the figures with two decimals?
