Rumus Excel Untuk Menghilangkan Angka Di Belakang Koma. If you want to remove decimal places in Excel, you can use a simple formula. The formula is =TRUNC (A1), where A1 is the cell that contains the number you want to truncate. This formula will remove all decimal places and return the whole number. If you want to keep a certain number of 8jvZAN7.