Excel 2000
 

Excel typically stores the actual number, regardless of format, UNLESS you
have applied the toolsoptions 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.

"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?