Hi guys

I was wondering if anyone can help.  I have sat for two days typing figures into a excel spreedsheet.  However I totally forgot to add on 10% to the prices that I typed in.  Is there an easy way to add 10% on to all fields to save having to retype the whole lot?

Hope someone can help

Mx

Try typing CellNumber/100*10+Cellnumber  (A1/100*10+A1) then left click bottom right hand corner and drag mouse down the column of cells, this should convert the formula for each cell.
Here's hoping!

Sorry you also need to put = first, so =A1/100*10+A1

Do you need to overtype the numbers with the correct ones or can you insert another column?

If you can insert another column then do as suggested above, although an easier formula is = Cell Number * 1.1 (so =A1*1.1).

If you need to overtype the existing numbers, then do as has already been suggested, copy the values, choose Paste Special and paste the values as oppose to the formulae over the top of the others.

Make sure you save a copy of your work before you do this incase it goes wrong ;) Also don't forget to use the fill handle to drag the formulae down - it will save you an awful lot of time :)