I am able to adjust the whole range of prices by paste special multiply.
Cant figure how to make the range round to the nearest whole dollar amount.
Why not just change the format of the column to currency with 0 decimal places?
> I am able to adjust the whole range of prices by paste special multiply.
> Cant figure how to make the range round to the nearest whole dollar amount.