price list rounding

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ROUNDING NUMBERS 3
column is added up by original figure not after rounding up 1
rounding to nearest hundred dollar in Excel 7
rounding to the nearest Dollar 2
What is the formula for rounding a dollar amount to the nearest ni 5
Round up to next half number 7
Setting a sale price and rounding up 4
applying rounding formula to entire worksheet 11

Back
Top