How to auto-increase values in currency formatted cells, by 10%.

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

Guest

How do you auto-increase all values sitting in currency formatted cells of a
worksheet, by a percentage value.
Thanks, PaulF
 
If you want to increase everything by 10%, put 1.1 in a spare cell, select &
copy, select the cells you want to increase, Edit/ Paste Special/ Multiply.
You can then delete the 1.1.
 
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

Average % - this should be easy? 2
Need Macro... 8
Change Currency Format of Cell based on another Cell 2
Percentage Increase 13
Using the Icon Set for Conditional Formatting 1
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Format Currency Cell 6
Increase Values by Percentage 1

Back
Top