Do operations on cell itself

[student]

hi,

Suppose i have cell with numeric values
eg

10 20 30

Now i want to multiply each value by 5. So how can i do that in the cell
itself display

50 100 150

I hope it makes sense

Thanks

 

[Harald Staff]

Hi

Enter 5 in an empty cell. Copy the cell.

Select your numerical cells. Go menu Edit > Paste special > check Multiply >
OK.

HTH. Best wishes Harald

 

[Frank Kabel]

Hi
try the following:
- put 5 in an empty cell
- copy this cell
- select your other data
- goto 'Edit - Paste Special' and choose 'Multiply'

 

[student]

Thanks a TON Harald and Frank. You guys are great.