Hi, thanks for the reply, just tried that and it gave me the percentage.

i.e. I typed 10% into A1 I then chose a cell with £10.00 in it, the result was £1.00 which is 10% of £10.00

Based on that, I did 110% and I got £11.00 which would be correct if I wanted to add 10% to that price, so thats a work around at least. Cool.

I think I still need a more elegant way to do this though, but at least for the time being I have a quick and dirty way to change prices en mass.

Thankyou