Thread: How to auto-increase values in currency formatted cells, by 10%.
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernard Liengme Bernard Liengme is offline
external usenet poster
  
Posts: 4,393
Default 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
...



Reply With QuoteReply With Quote