Get instant live expert help with Excel or Google Sheets
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Our professional experts are available now. Your privacy is guaranteed.

Thousands and millions format – Excelchat

While working in Excel, we can simplify how we present large numbers and display the values in thousands or in millions.  All we have to do is make some adjustments in the format.  

Figure 1.  Final result: Thousands or millions format

Format in thousands

We want to convert the values in column B to thousands by following these steps:

  • Select the cells we want to format, C3:C8
  • Right click and select Format Cells or press Ctrl + 1

Figure 2.  Format Cells option

  • In the Format Cells dialog box, select Custom in Number tab
  • In the text box for Type:, enter  0, “K”

Figure 3.  Custom Format Cells dialog box

The values in column C are now displayed in thousands, with a “K” to indicate thousands.  We can opt to remove the K by simply entering “0,” in the text box for Type.

Figure 4.  Output: Format in thousands

Note that the values are still intact and the same as shown in the formula bar, where C3 still has the value “102,345”.  Only the format is changed, where all numbers are presented as thousands.

Format in millions

In the same manner, we can convert numbers into millions.

  • In the Custom window of Format Cells, we enter 0,, “M” in the text box for Type:

Figure 5.  Custom Format for Millions

All numbers are now converted into the Millions number format.  Note in cell D8 where the number is rounded off to the nearest millions but only as displayed.  The original value of “14,698,781” still remains the same.

Figure 6.  Output: Millions Format

By customizing the format of numbers, we can easily convert thousands to millions and vice versa.  We can even format numbers in billions by using the format 0,,, “B”.  We can further navigate the Custom Format feature to learn several other ways to present our data.  

Instant Connection to an Excel Expert

Most of the time, the problem you will need to solve will be more complex than a simple application of a formula or function. If you want to save hours of research and frustration, try our live Excelchat service! Our Excel Experts are available 24/7 to answer any Excel question you may have. We guarantee a connection within 30 seconds and a customized solution within 20 minutes.

Leave a Comment

avatar

Subscribe to Excelchat.co

Get updates on helpful Excel topics

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc