How to format large numbers in thousands or millions and be able to use them in formulas:
If you want to format large numbers into thousands or millions, here are the steps:
1) Highlight the cells to be formatted
2) Go to the format dialog box ( Ctrl + 1)
3) Under Category select Custom
4) In the Type box, for Thousands enter #,###, “K” for Millions enter #,###,, “M”
5) Click OK
The comma after the pound sign indicates to Excel to skip the 000. So for Millions, we entered two commas to skip 2 sets of 000.