Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 33
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
I type in a number in a cell but it wont convert to currency help Out in VA Excel Worksheet Functions 2 May 28th 10 12:04 AM
How do I set up worksheet tabs to change based on a workbook cell LJVG Excel Worksheet Functions 1 January 16th 09 06:15 PM
Change Currency Format of Cell based on another Cell Simon Excel Worksheet Functions 2 September 2nd 07 04:53 PM
How do I automatically change currency depending on another cell . Conrad Excel Programming 0 September 27th 04 03:51 PM
Determine the type of currency in a cell Anders[_6_] Excel Programming 2 January 11th 04 02:39 PM


All times are GMT +1. The time now is 10:33 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"