Main Page » MS Excel Functions » Show n Decimal Digit Without Rounding


Show n Decimal Digit Without Rounding


Suppose you have a decimal number like (“123.456”) and you want to show only two decimal digit without rounding like (“123.45”).
As you see in the table below, you may use these formulas.

=TRUNC(B9;2)
=FLOOR(B9; IF(B9>0; 0.01;-0.01))  
=VALUE(IF(FIND(".";B9;1)>0;LEFT(B9;FIND(".";B9;1)+2);B9))

If you prefer =FLOOR formula, don't forget to increase digits of 0.01 depends on your choice. For two digit 0.01, for there digits 0.001, for five digit 0.00001 etc.
If you prefer =VALUE formula, first of all be sure your decimal delimiter is dot (.) otherwise you should change the formula to comma (,).
show n decimal digit without rounding
You can download running sample from below link.
Download example file