Excel 2007 : Adding mark up to a column of existing numbers.

I've got a column of over 36000 sales prices. I want to do a markup of say 5%. Is there a macro to achieve this?

Here's a twist the numbers do not have decimal points, so 381 is actually 3.81 and 1515 is actually 15.15.
I know how to insert the decimal points (Paste Special on the whole column from a copied cell with .01 in it) but I can't figure out the mark up. I thought I had it by doing another Paste Special on the whole column with 1.05 in it but I was informed I didn't do a true mark up.

Any help would be appreciated.

Thanks,
AManly

Originally Posted by davesexcel

Do you mean by pasting the cell that has 1.05 in it then selecting the range to markup, then pasteSpecial=> Multiply, will not increase those values by 5%... why not?

Yes that does increase the values by 5% but apparently that isn't a "true markup" in figuring profit margin.