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