| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using Index Match etc. for price list | Excel Worksheet Functions | |||
| Price List overall price increase | Excel Discussion (Misc queries) | |||
| Return a price based on a customer from a drop down list | Excel Discussion (Misc queries) | |||
| create price list from excel sheet | Excel Discussion (Misc queries) | |||
| looking to update price list, wanted to up charge list by 35% . | Excel Worksheet Functions | |||
Linear Mode
