Increasing values in Price column
That did the trick - thank you to both of you who responded! What a great
community :)
"Ron Coderre" wrote:
Try this:
Enter 1.20 in a cell
Copy that cell
Select the cells of your current list prices
<edit<paste special
Check: Multiply
Check: Values
Click the [OK] button
When done, delete the contents of the cell holding 1.20
Does that help?
***********
Regards,
Ron
XL2002, WinXP
"Gold N Silver" wrote:
Hi,
I run a business and in my spread sheet I have a column for prices - Since
gold and silver have risen to all time highs I need to increase the prices by
20% - there are over 24,000 items - is there an easy way to do that ?
Thanks for your help !
|