Excel price list work

The following will only take a few mins to do. I know because I have done it. The problem is (apart from the fact I'm a bit of a muppet on Excel) when I go to copy and paste the figures from one spread sheet to another the word "Value" just pops up, not the actual figures. Not only that but when you go in to one of the boxes of the final figure it states how I worked the final figure out and I can't have customers seeing that!

This is what I would like a freelancer to do:

Column A has product prices in US Dollars. I need that figure to be changed in to Sterling, then add 5%, then add £20, then add 4%, then add 20% then add 30% and lastly round the final figure up to the nearest pound.

Like I say, I've done all the above but I can't successfully transfer the data from one sheet without the word "value" showing to another and I also don't want the calculation to be shown.

If someone could fix this for me this weekend that would be great as my boss is back on Tuesday and he can do this himself... Looking for brownie points!

Thanks.