Rounding Problem

[astole]

I have 3.3277777778.

I need it to show 3.32 and not 3.33

Currently I am using the $#,##0.00_);[Red]($#,##0.00);_(* "-"??_)

[martindwilson]

i dont think you can with custom formatting,why not use rounddown() around your value?

[oeldere]

I agree with martindwilson.

Notice that the formula rounddown will change the result if you gonna count with it (e.g. multiply).

[astole]

How would you round down? Never had to deal with rounding before.

[gpetlow]

It can be done with a formula
3.327777778 3.32 =TRUNC(A1*100)/100 or simply =trunc(A1,2)

[FDibbins]

=ROUNDDOWN(A1,2) will do exactly the same thing (as suggested already)