wrote:
After you have... "Paste Special Values Multiply OK"
your field of prices that you have just increased should
still be selected. Click Home Number 'click decrease
(or increase) decimal points icon' until two.

That affects only the __appearance__ of the result. The __actual__ value
might still have digits beyond 2 decimal places.

The only way this procedure would alter the __actual__ value is if the
"Precision as displayed" calculation option is set.

If you are already using PAD, that's fine.

Otherwise, it would be misguided and dangerous to set PAD just for this
purpose.

PAD affects the entire workbook as soon as it is set. That is, it might
round unintended cells. If those cells contain constants, they would be
changed irreversibly.