Skip to content

Rounding To Millions In Excel, by Easan Katir

2007-02-01 · Easan Katir
Original source

Once upon a time, a fellow trader kindly tipped the way to put '+' signs into excel numbers, which inspired one to pass along the following:

Rounding Numbers to Millions

To round numbers to millions:

  1. Press Ctrl+1 to open the Format Cells dialog box.
  2. Select the Number tab, and from Category, select Custom.
  3. In the Type box, enter the following Custom Formatting syntax:

,##0,, ;Red;- ;

Result:
Original number: 5,645,625
The displaying formatted number: 6

Note: The number formatting syntax is: Positive; Negative; 0; Text

No doubt this will give that trendy 'white space' look of many a Spec's balance sheet.