You are here: Features > Rounding > To enable rounding at the click of a button

Enabling Rounding at the Click of a Button

  1. On the Tools tab, click Rounding.

  2. In the Rounding dialog, configure the rounding or rounding relations as you prefer and click OK.
  3. On the Home tab, click Cell.

  4. Select a cell type. The most common choices are check box or button.
  5. Click the Events tab.
  6. In the Events drop-down list, select On Click and click Add.
  7. In the Action drop-down list, select Round To.
  8. In the Round To box, enter one of "1", "1000", or "1000000".
  9. If desired, enter skip conditions for the event. When the Run Skip Condition is evaluated to be true, the action is not performed.
  10. Click OK.

When the User selects the cell, the appearance of the numbers in the document changes according to the rounding option selected.

Related Topics