Add millions as a unit to ensure you don't confuse the format with regular numbers. Open your spreadsheet in Microsoft Excel. Click and drag your mouse cursor over the cells you wish to format.

To show numbers in thousands or millions in Excel, you can use these two formatting conditions: #0,”K” and #0,,”M”. To apply them, select the cell, right-click on it, and select the Format ...

The solution is to reduce the look of the numbers to a more manageable value. To do this, right-click the chart’s Y-axis and choose Format Axis > Number tab. Click on Custom – as you can see, you can ...

Enter custom format codes in the Type field to display numbers in thousands or millions. For example, use 0, “K” for thousands or 0,, “M” for millions. While custom format codes are easy ...