Data series conversion
 

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

Data series conversion
 

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

"barney633" wrote:

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

Data series conversion
 

Many thanks, easy when you know how!
Thanks again.

"Mike H" wrote:

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

"barney633" wrote:

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