top of page
Services offered worldwide
or
Your partner in computer software training & application development
for over 25 years
Microsoft Excel
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.
bottom of page