Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
thanks for the tip , it worked perfect!
"Ken Wright" wrote: Do you want to lose the existing values? 1) Keeping existing values, simply use another column and use a formula such as =A2*1.1 and copy down. 2) Replacing existing values, put 1.1 in any empty cell, then copy that cell. Select all your values and then do edit / paste special / values & multiply -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ------------------------------Â*------------------------------Â*---------------- It's easier to beg forgiveness than ask permission :-) ------------------------------Â*------------------------------Â*---------------- "mowerman" wrote in message ... at our store we have price sheets in excell and i want to raise the list prices all at one time to 10% higher . can i do this and how |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) | |||
help with quote program using muliple prices for one quantity {cross post} | Excel Discussion (Misc queries) | |||
Extracting Values on one list and not another | Excel Discussion (Misc queries) | |||
How do I find out what items are in one list but not in another l. | Excel Discussion (Misc queries) | |||
Creating a list from an existing list. | Excel Worksheet Functions |