Excel 2000
 

Do you mean that the value might be 12.6%, but this shows as 13% and
you want it to show as 12%?

If that is the case then you will need to amend your formula that
produces the percentage as follows:

=ROUNDDOWN(your_formula,2)

then copy this down the column if necessary. If you want to show 1
decimal place, then make it:

=ROUNDDOWN(your_formula,3)

Hope this helps.

Pete

On Oct 16, 6:48 pm, MaxiMai wrote:
Working with a worksheet that has payroll calculations. Some cells that are
included in the calculation has % formating, which is some cases causes the #
seen in the cell to round up.

Can that be stopped? I do not want the figure to round up at all. I also
do not want to show all the digits by increasing the decimal point.

Again, can this be done?