Data series conversion

  • Thread starter Thread starter barney633
  • Start date Start date
B

barney633

I need to multiply a complete column of data. I don't need to keep to
original data only the results. I've been using a new column and then cutting
and pasting the data back to it's original position. Is there a method of
doing this that will just overwrite the original data without the need for
all the cutting and pasting?

Many Thanks
 
Hi,

Put the multiplier in a call and copy it.
Select the colmn to multiply and then
Edit|Paste Special
Select Multiply and click OK
Delete the multiplier.

Mike
 
Back
Top