With Placeholder Zero (0) & Decimal Pointįortunately, large numbers in Excel can be formatted so they can be shown in “Thousands” or “Millions”.īy using the Format Cells dialogue box shortcuts CTRL+1, you will need to select CUSTOM and then enter one comma to show Thousands or two commas to show Millions.In this article, you will learn about how to do Excel format millions & thousands using: Say, a number 45,200,000 will be displayed as 45.2 Million.
The best way is to show the numbers in Thousands (K) or Millions (M). Many times, you might have large numbers in an Excel report and it is hard to decipher and read the number at one glace. 101 BEST EXCEL TIPS & TRICKS E-BOOK! Excel custom number format Millions and Thousands
