Presenting the Figures in the Fiveyear Balance Sheet Report in Thousands

It may be difficult to read the figures side-by-side in the five-year Balance Sheet comparison report if the numbers are not rounded to the thousands. In this section you will learn how to easily round the numbers to the thousands, as well as how to correct the display totals of the presented rounded numbers.

It is not convenient to use a ROUND formula to round numbers to the thousands, as it adds one more formula to the formulas already in the cells. It also makes auditing more complicated, uses more memory and expands the workbook size.

Instead, you should use Custom Formatting to round numbers to the thousands.

0 0

Post a comment