DJH Training & Application Solutions | Excel Format Values as Thousands, Millions, and Billions
Computer Training & Application Solutions made Simple
Contact us for a free consultation
  • Click to send us an email. We'd love to hear from you!   Ottawa       613-656-4229
  • Click to send us an email. We'd love to hear from you!   Montreal    514-342-9494

Format Values to Display by Thousands, Millions or Billions

Courtesy of
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:

  1. Select the cell(s) that contains the values
  2. Ctrl + 1 to open the Format Cells dialog box
  3. On the Number tab in the resulting dialog box, click the Custom category
  4. 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 that Excel will round up or down as necessary.

More Newsletter Articles

© 2015 DJH Training & Application Solutions Inc.

WOULD YOU LIKE TO USE THIS ARTICLE IN YOUR NEWSLETTER, EZINE OR WEB SITE? You can, as long as you include this complete blurb with it: An entrepreneur at heart, Deborah J. Sparks established DJH Training & Application Solutions Inc. over 20 years ago, realizing her dream of creating a company known for providing high quality computer software training, application development and support and exercising her passion for teaching. To learn more and to register for DJH's free newsletter, Innovations, please visit