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

 Excel Tutorial - Rounding Up Large Numbers Training Melaka Puchong Selangor, Malaysia

 

2.  Select cell B2:B11, and change the number format to

 

 [>=1000000]0,,"M";[>=1000]0,"K";0 

 

 

Try this out:

 

Excel Tutorial - Rounding Up Large Numbers Training Melaka Puchong Selangor, Malaysia

 

By Bee Bee Ong

Cempaka Technology Sdn Bhd

Pusat Latihan Komputer Cempaka
~Your HRDC Premiere Training Provider~
Unit 6, Level 4, SetiaWalk Mall (Block K), SetiaWalk, Persiaran Wawasan, Pusat Bandar Puchong, 47160 Puchong, Selangor, Malaysia.
Tel: 603-80684461, Fax: 603-80684240
1-28, Jalan PM4, Plaza Mahkota, 75000 Melaka, Malaysia
Tel: 606-2835955, Fax: 606-2845955