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
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
  
Posts: 8,651
Default How to auto-increase values in currency formatted cells, by 10%.
If you want to increase everything by 10%, put 1.1 in a spare cell, select &
copy, select the cells you want to increase, Edit/ Paste Special/ Multiply.
You can then delete the 1.1.
--
David Biddulph

"PaulF" wrote in message
...
How do you auto-increase all values sitting in currency formatted cells of
a
worksheet, by a percentage value.
Thanks, PaulF


Reply With QuoteReply With Quote