Format Large Numbers Into Thousands Or Millions In Excel

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.

Happy Excelling!

Free Download!

Subscribe to Download Your FREE Copy of
"My 70+ Favorite Excel Keyboard Shortcuts" Today!

No comments yet.

Leave a Reply