Excel Guides

Notation for Thousands and Millions in Excel

When working with large numbers in Excel, it is often useful to format them in a way that makes them easier to read. One way to do this is to use notation for thousands and millions. This can be done by using the Format Cells dialog box, or by using a number format code.

To format a cell using the Format Cells dialog box:

  1. Select the cell or range of cells that you want to format.
  2. On the Home tab, in the Number group, click More Number Formats. This opens the Format Cells dialog box.
  3. In the Category list, click Custom. This displays the Custom category
  4. .
  5. In the Type: box, type one of the following codes:

#,##0 - formats the number with a comma for every thousand place

#,### - formats the number with a space for every thousand place

0,, - formats the number with a comma for every million place



  1. Click OK. The number will now be formatted using notation for thousands and/or millions.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.