Don't worry, you can put the tissue box away.

In an empty cell type: 1.05

Now copy that cell

Next, highlight all the cells you want to increase by 5%

Now click on Edit Paste Special and in the "Operation" area choose
Multiply

Now click OK

All done, no crying. Now delete the 1.05 that you typed in that empty
cell


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=511356