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





Try this out:



By Bee Bee Ong  | Google


Cempaka Technology Sdn Bhd

Pusat Latihan Komputer Cempaka
~Your HRDC Premiere Training Provider~
64-2, Jalan Puteri 2/2, Bandar Puteri Puchong, 47100 Puchong Selangor, Malaysia. Tel: 603-80684461
1-28, Jalan PM4, Plaza Mahkota, 75000 Melaka. Tel: 606-2835955
Instant SSL