How to auto-increase values in currency formatted cells, by 10%.
|
How to auto-increase values in currency formatted cells, by 10%.
In an empty cell (say B1) type 1.10 (for 10%, 1.05 for a 5% ,etc)
Copy B1 Select all the cells to fix; use Edit |Paste Special and specify multiply Now delete B1 best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "PaulF" wrote in message ... |
All times are GMT +1. The time now is 08:22 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com