Tom’s Tutorials For Excel: Formatting Numbers for Thousands or Millions
When you have a range of large numbers that can be difficult to comprehend because of their size, it helps to make the range more readable by formatting the numbers as thousands or millions.
The first step in formatting the cells is to select the range, right-click the selected range, and click Format Cells from the popup menu to show that Format Cells dialog box. Alternatively, with the range selected, from your keyboard you could press
To format the numbers in millions, with an indicative “M” suffix and a decimal for fun:
• Click onto the Number tab.
• In the Category list, select Custom.
• In the Type field, enter
• Click OK.