Change Cell Value Across whole WorkSheet/ Workbook if cell type is currency

  • Thread starter Thread starter Shashi Bhosale
  • Start date Start date
S

Shashi Bhosale

Is there a way to change Cell value to add 4% more across whole WorkSheet/
Workbook if cell type is currency ?
 
do you want to increment existing values by 4%?

in a blank cell, enter 104%

Then select that cell and do Edit=>Copy

now select the cells you want incremented and do

Edit=>Paste Special and select values and multiply.
 

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

Back
Top