Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change Cell Value Across whole WorkSheet/ Workbook if cell type is currency
Is there a way to change Cell value to add 4% more across whole WorkSheet/
Workbook if cell type is currency ? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change Cell Value 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. -- Regards, Tom Ogilvy "Shashi Bhosale" wrote in message ... Is there a way to change Cell value to add 4% more across whole WorkSheet/ Workbook if cell type is currency ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I type in a number in a cell but it wont convert to currency help | Excel Worksheet Functions | |||
How do I set up worksheet tabs to change based on a workbook cell | Excel Worksheet Functions | |||
Change Currency Format of Cell based on another Cell | Excel Worksheet Functions | |||
How do I automatically change currency depending on another cell . | Excel Programming | |||
Determine the type of currency in a cell | Excel Programming |