Excel question

[h2009]

Hi there,
I've got a big list of numbers that i need to adjust the figures of showing the result in same cell, as the original. If you look below, for example needing to add 17% to each cell, where each cell has a different number. Basically i need to preserve the original figure, yet updating the cell with add/subtracting/multi/percent.

Is there anyway to do this, fast, instead of retyping each cell?

i.e.
Original
A1 = 100
A2 = 200
A3 = 150

Changed
A1 = 100 +17%
A2 = 200 +17%
A3 = 150 +17%

 

[RobH]

Why not calculate the new value in a new cell and then copy it back?

For example put this fomula in B1:

=A1*1.17

Then drag the formula down as many rows as you need and then copy the data back to the A Column and do Paste Special > Values.

 

[h2009]

thanks for your reply.
But i was hoping to have a reference cell i.e. if i put 22% in C1, then all of A cells update, accordingly.

The only way i can think about doing this is on a new sheet :/ but that like a 'cut and weld' job.

 

[skiba]

Can you maybe use the reverse of 'text to column' if one exists? I know that splits where you want it to, maybe it will merge.

 

[Participant]

If all your original numbers are in column A, in column B use "=A1*1.17". Then do copy, paste special, paste formulae back into column A.