ExcelBanter - price list rounding

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - price list rounding (https://www.excelbanter.com/new-users-excel/116110-price-list-rounding.html)

francesclaire1

price list rounding

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.

luvthavodka

price list rounding

Why not just change the format of the column to currency with 0 decimal places?

"francesclaire1" wrote:

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.

All times are GMT +1. The time now is 11:12 AM.