numbers to currency without rounding

[u15986]

So cell B-2 is an amount in currency. Cell B-3 is 3% of that amount. When that calculation is completed, the result may be carried three or four decimal places. When the result of that calculation shows up in B-3, it rounds up to the nearest penny. How do I stop that from occurring ?

 

[mumps]

Try this formula in cell B3 : =TRUNC(B2*0.03,2)

 

[West Man]

Cell B3 displays only 2 decimals because Excel is formatting the result as currency. When the underlying number is greater than or = to 5 at the 3rd decimal, it rounds up the displayed number. If you wish never to round up, u15986 has provided a solution. If instead you wish to see past the 2nd decimal you need to format the cell to show more decimals.