" wrote in message
...
Hi

I have a spreadsheet with stacks of £0.00 figures but need to increase
these by 1.3%, so rather than manually doing it, can this be automated
with a formula.

What I dont want is an additional column, I just need to increse each
cell

Type in a "spare" cell 1.013. Right click it, select "Copy". Highlight all
the cells you want to increase, select "Paste Special" and "multiply".
That's the easy way, but you lose all audit trail with that method.
If you need to keep track of how you got the numbers then you will need to
put in another formula. (You can always hide the calculating column - and
you can also bet your boots that someone sometime is going to say "how did
you get those numbers....")