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

 

 

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

 

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