Tip Printed from ExcelTip.com

---

Displaying Figures in Financial Reports Rounded to Thousands


By easily changing the Style in the Style box, you can quickly change the presentation of numbers in any report. For example, display and print reports with figures rounded to the thousands.

To apply a Style:

1. Add the Style box to the Formatting toolbar (see Tip #67).
2. Create a new Style and name it Round To Thousands (see Tip #67).
3. Select the columns containing the numbers to round.
4. From the Style box, select Round to Thousands.