Format Values to Display by
Thousands, Millions, or Billions
© 2015 DJH Training & Application Solutions Inc.
For clarity and to take up less "real estate" on worksheets, try the number formats below to display your values by thousands, millions or billions:
To apply number formats:
Select the cell(s) that contains the values
Open the Format Cells dialog box > Number tab > Custom category
Delete the format displayed in the Type: box and type one of the formats above (the Sample box will display a preview of the result)
Note: Excel will round up or down as necessary.