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

 

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