Excel 2000

[Guest]

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?

 

[Guest]

Excel typically stores the actual number, regardless of format, UNLESS you
have applied the tools>options selection to "precision as displayed".
Just tested with 1/12 dispalyed as %, general and number set to 2 deciaml
places. multiplied by 100 which returned 8.33333333 in each case.

 

[Pete_UK]

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