Yes there is. In an empty cell, enter 1.10
Copy this value
Select the cells to multiply
Right click - Paste Special- Multiply - OK
EDIT here is a similar example you should know of http://www.excelforum.com/excel-gene...54#post2831654
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
|