Do operations on cell itself

  • Thread starter Thread starter student
  • Start date Start date
S

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
 
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
 
Hi
try the following:
- put 5 in an empty cell
- copy this cell
- select your other data
- goto 'Edit - Paste Special' and choose 'Multiply'
 
Back
Top