Main Page » MS Excel Functions » 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 (,).

You can download running sample from below link.

Download example file

Sitede yer alan her şey -kaynak gösterilmesi ricasıyla- serbestçe kullanılabilir.

** MCUMA ©** 2007 - 2018