Excel Tutorial - Rounding Up Large Numbers
Do you ever need to round up a large numbers for easy reading? Like 1234 to 1K, 1234567 to 1M.
Here is some of the formatting that you may try:
1. Number format that shows numbers as millions with an M, thousands with a K
2. Select cell B2:B11, and change the number format to
[>=1000000]0,,"M";[>=1000]0,"K";0
Try this out:
By Bee Bee Ong | Google