# Excel 2min Tip: Round your budgets to the nearest thousand

**To display figures to the nearest thousand, use the Format – Custom feature and include three things: a dot, a zero, and a comma.**

**Example:**

To display the numbers on the left as the numbers on the right, follow these steps:

1021.76...........1.1

560...................0.6

540...................0.5

21.....................0.0

1345.26...........1.3

-520.78...........-0.5

- Type the first column of numbers into Excel, column A. Then copy them into column B.
- Highlight column B.
- From the menu, choose
**Format, Cells, Custom**(at the bottom). If you are using Excel 2007, right-click the selected column, choose**Format Cells**, and then choose**Custom**at the bottom of the list. - In the Type box, delete the current entry (the default entry is
*General*).In the now-empty Type box, enter this sequence:

**##,##0.0,;[Red]-##,##0.0,**The first model above, before the semi-colon, refers to the presentation of positive numbers; the second (red) model refers to the presentation of negative numbers. You can remove the

**[Red]**if you don't want red in your worksheet.Make sure you include the zeros, decimal places, and don't forget the commas at the end of both the positive and negative sequences.

- Press OK. The numbers are now nicely rounded to the nearest thousand.

*By David Carter*

[1] |