Excel Tutorial - Truncating Large Numbers

 

 

This is tutorial Truncating Large Numbers for Excel.

Do you ever need to truncate up a large numbers for easy reading? Like 12100 to 12, or 12999 to 13:

1. Truncate the last three digits of a number in the thousands

 Excel Tutorial - Truncating Large Numbers Training Melaka Puchong Selangor, Malaysia

 

2.  Select cell B2:B5, and change the number format to 0, as shown below:

Excel Tutorial - Truncating 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