Forum Discussion
Lee_Jackson76
Sep 12, 2022Copper Contributor
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'...
Riny_van_Eekelen
Sep 12, 2022Platinum Contributor
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)
- Lee_Jackson76Sep 12, 2022Copper Contributor
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?