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

"student" <(E-Mail Removed)> skrev i melding
news:(E-Mail Removed)...
> 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
try the following:
- put 5 in an empty cell
- copy this cell
- select your other data
- goto 'Edit - Paste Special' and choose 'Multiply'
>-----Original Message-----
>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
>
>
>.
>

Thanks a TON Harald and Frank. You guys are great.
"Frank Kabel" <(E-Mail Removed)> wrote in message
news:077b01c4900d$49251c80$(E-Mail Removed)...
> Hi
> try the following:
> - put 5 in an empty cell
> - copy this cell
> - select your other data
> - goto 'Edit - Paste Special' and choose 'Multiply'
> >-----Original Message-----
> >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
> >
> >
> >.
> >