See all How-To Articles

Number Format – Thousands (000s) in Excel & Google Sheets

This tutorial demonstrates how to format numbers as thousands (000s) in Excel and Google Sheets.

 

thousands number format initial data

 

Format Numbers as Thousands

When working with financial (or other similar) reports, you’ll always face large, robust numbers. In order to make them look slick, you can format numbers as thousands (000). Say that you have the following set of numbers in column B.

 

thousands number format initial data

 

In order to format the list of numbers as thousands, follow the next steps.

1. (1) Select a range of numbers (B2:B7), and in the Ribbon, (2) go to the Home tab and (3) click the Number Format icon in the right bottom corner of the Number group.

 

thousands number format 1

 

2. In the Format Cells window, (1) go to the Custom category, and (2) enter “#,##0,” in the Type box, and (3) click OK.

 

thousands number format 2

 

As a result, all numbers in the range, are formatted as thousands (000s).

 

thousands number format 3

 

You can also use K to indicate thousands. This can be useful when creating scorecards to present KPI metrics. In that case, just enter “#,##0,”K”“.

 

thousands number format 4

 

See also: Find out how to format numbers as millions.

Format Numbers as Thousands in Google Sheets

Similar to Excel, you can also format numbers as thousands in Google Sheets. To achieve this, follow the next steps.

1. (1) Select a range of numbers B (B2:B7), and in the menu, (2) go to the Format > Number > Custom number format.

 

google sheets thousands number format 1

 

2. In the Number format box, enter “0,“. One comma means that the last 3 digits in the number will be omitted.

 

google sheets thousands number format 2

 

As a result, the numbers are formatted as thousands (000s).

 

google sheets thousands number format 3

 

To format with K, enter “0,\K“.

 

google sheets thousands number format 4