Calculation to replace the cell contents

[Dave Neve]

Sorry to ask such basic questions but I only use Excel once a year for end
of term marks.

I have a column with results /82 eg; 56, 27, 49 (all out of 82)

I want to convert the mark to /20 (out of 20) and for the results to replace
the marks out of /82.

So the formula should be mark/82 x 20 = mark out of 20

Could sm tell me apply this formula so that Excel will recalculate the
column for me?

Thanks in advance

[Gary''s Student]

Hi Dave:

You want to scale numbers in place:

1. in an un-used cell enter =20/82
2. copy this cell
3. select all the cells in the column you wish to re-scale
4. pull-down:
Edit > Paste Special... > and check the multiply button.

Have a pleasant day !
--
Gary's Student


"Dave Neve" wrote:

> Sorry to ask such basic questions but I only use Excel once a year for end
> of term marks.
>
> I have a column with results /82 eg; 56, 27, 49 (all out of 82)
>
> I want to convert the mark to /20 (out of 20) and for the results to replace
> the marks out of /82.
>
> So the formula should be mark/82 x 20 = mark out of 20
>
> Could sm tell me apply this formula so that Excel will recalculate the
> column for me?
>
> Thanks in advance
>
>
>
>

[Dave Neve]

Hi

Unfortunately, nothing happens.
Could I be missing sth here.
"Gary''s Student" <GarysStudent@discussions.microsoft.com> a écrit dans le
message de news: D2BCCB43-C2B2-46AA-9A34-9FC5FBCBADA0@microsoft.com...
> Hi Dave:
>
> You want to scale numbers in place:
>
> 1. in an un-used cell enter =20/82
> 2. copy this cell
> 3. select all the cells in the column you wish to re-scale
> 4. pull-down:
> Edit > Paste Special... > and check the multiply button.
>
> Have a pleasant day !
> --
> Gary's Student
>
>
> "Dave Neve" wrote:
>
>> Sorry to ask such basic questions but I only use Excel once a year for
>> end
>> of term marks.
>>
>> I have a column with results /82 eg; 56, 27, 49 (all out of 82)
>>
>> I want to convert the mark to /20 (out of 20) and for the results to
>> replace
>> the marks out of /82.
>>
>> So the formula should be mark/82 x 20 = mark out of 20
>>
>> Could sm tell me apply this formula so that Excel will recalculate the
>> column for me?
>>
>> Thanks in advance
>>
>>
>>
>>

[Paul Lautman]

Dave Neve wrote:
> Hi
>
> Unfortunately, nothing happens.
> Could I be missing sth here.
Well the only thing missing from Gary's Student's instructions was to press
OK after checking the multiply button.
Apart from that it works fine for me, so I guess you must be missing
something as everything else is there.


> "Gary''s Student" <GarysStudent@discussions.microsoft.com> a écrit
> dans le message de news:
> D2BCCB43-C2B2-46AA-9A34-9FC5FBCBADA0@microsoft.com...
>> Hi Dave:
>>
>> You want to scale numbers in place:
>>
>> 1. in an un-used cell enter =20/82
>> 2. copy this cell
>> 3. select all the cells in the column you wish to re-scale
>> 4. pull-down:
>> Edit > Paste Special... > and check the multiply button.
>>
>> Have a pleasant day !
>> --
>> Gary's Student
>>
>>
>> "Dave Neve" wrote:
>>
>>> Sorry to ask such basic questions but I only use Excel once a year
>>> for end
>>> of term marks.
>>>
>>> I have a column with results /82 eg; 56, 27, 49 (all out of 82)
>>>
>>> I want to convert the mark to /20 (out of 20) and for the results to
>>> replace
>>> the marks out of /82.
>>>
>>> So the formula should be mark/82 x 20 = mark out of 20
>>>
>>> Could sm tell me apply this formula so that Excel will recalculate
>>> the column for me?
>>>
>>> Thanks in advance