Hi
I have a spreadsheet of numerical values and I simply want to increase all
values, in all cells, by 17.5%. Can anyone please tell me how to do this?
Many thanks
David
Hi
I have a spreadsheet of numerical values and I simply want to increase all
values, in all cells, by 17.5%. Can anyone please tell me how to do this?
Many thanks
David
David
Type 1.175 in a spare cell and copy it... Highlight your numbers and then
edit>paste special...>values+multiply
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
[email protected]HIS
"David" <[email protected]> wrote in message
news:[email protected]...
> Hi
>
> I have a spreadsheet of numerical values and I simply want to increase all
> values, in all cells, by 17.5%. Can anyone please tell me how to do this?
>
> Many thanks
> David
>
>
>
Many thanks for this. Saved me a lot of mouse work! Why the help couldn't
explain this I don;t know...too concerned with complex things and forgets
the fundamentals.
Cheers
David
"Nick Hodge" <[email protected]> wrote in message
news:%[email protected]...
> David
>
> Type 1.175 in a spare cell and copy it... Highlight your numbers and then
> edit>paste special...>values+multiply
>
> --
> HTH
> Nick Hodge
> Microsoft MVP - Excel
> Southampton, England
> www.nickhodge.co.uk
> [email protected]HIS
>
>
> "David" <[email protected]> wrote in message
> news:[email protected]...
>> Hi
>>
>> I have a spreadsheet of numerical values and I simply want to increase
>> all values, in all cells, by 17.5%. Can anyone please tell me how to do
>> this?
>>
>> Many thanks
>> David
>>
>>
>>
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks