Forum Discussion
ChrisM1222
Jun 14, 2023Copper Contributor
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...
- Jan 06, 2022attachments can easily Bloat db, especially when the images you are saving is very big.
the advised is use Short text and store the Path+filename of the image (usually stored in Common location).
HansVogelaar
Jun 14, 2023MVP
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.