Enabling Rounding at the Click of a Button
-
On the Tools tab, click Rounding.
- In the Rounding dialog, configure the rounding or rounding relations as you prefer and click OK.
-
On the Home tab, click Cell.
- Select a cell type. The most common choices are check box or button.
- Click the Events tab.
- In the Events drop-down list, select On Click and click Add.
- In the Action drop-down list, select Round To.
- In the Round To box, enter one of "1", "1000", or "1000000".
- If desired, enter skip conditions for the event. When the Run Skip Condition is evaluated to be true, the action is not performed.
-
Click OK.
When the User selects the cell, the appearance of the numbers in the document changes according to the rounding option selected.