Forum Discussion

Lee_Jackson76's avatar
Lee_Jackson76
Copper Contributor
Sep 12, 2022

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't change the data already entered.  Is there a way to do that?

 

excel

2 Replies

Sort By
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    Sep 12, 2022

    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_Jackson76's avatar
      Lee_Jackson76
      Copper Contributor
      Sep 12, 2022

      Riny_van_Eekelen 

       

      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?

Resources