Forum Discussion
Rounding
How can I round an entire section of numbers at one time without going into each formula and adding the Round function? I want the calculated number to end up with only 2 decimal points and not just...
One possible solution:
- Select File > Options.
- Select Advanced.
- Scroll down to the section 'When calculating this workbook'.
- Tick the check box 'Set precision as displayed'.
- Click OK.
- Set the number format of the cells to Number with 2 decimal places.
- Excel will round the stored values of the cells to 2 decimal places.
- Warning: this will affect all formatted cells in the workbook. It won't affect other workbooks.
Another option would be VBA code.
this only displays the number as 2 decimal places but the actual number in the cell extends past that.
Not the case here or I don't understand what you mean with "the actual number in the cell extends past that"
