Stop Excel from displaying "rounded" numbers

[dingo114]

Hello

I am working on a sheet which I will have to send off to the payroll department for the pay of sick aid it is essential that the amount calculated shows the result with two decimals without rounding it!...

i.e.: the result is 69.6666666666..... => when I set the cell to only show two numbers after the decimal it shows 69.67 however I need it to display 69.66 as it is essential for the correct payment...

Can anyone help??

thanks!

 

[vlady]

=trunc(yourformula,2)

 

[shahfahad]

=ROUNDOWN(Amount,2)

 

[Peter_SSs]

Try

=ROUNDDOWN(A2,2)

 

[dingo114]

Thank you all for your quick reply... Trunc works like a charm for me

Thanks all!!!!!