Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is there a shorten way to increase the value
Hi Everyone,
1 had a file with a lot of number thru out the cell and now I wish to increase the value to another 20% on the below table. Is there a way I highlight it an just x 120% A B C D E F G 1 1 9 2 2 6 5 6 2 3 5 4 6 2 21 24 3 5 21 56 4 14 6 24 4 7 2 69 59 9 4 86 5 9 9 7 2 5 88 35 6 10 4 8 5 2 2 7 7 45 5 1 9 10 6 59 8 19 3 5 58 6 7 1 9 20 8 6 6 97 2 4 10 5 8 2 2 69 39 7 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is there a shorten way to increase the value
--Enter 1.2 in a cell and Copy the cell
--Keeping the copy Select your data --Right clickPasteSpecialMultiplyOK If this post helps click Yes --------------- Jacob Skaria "Sky" wrote: Hi Everyone, 1 had a file with a lot of number thru out the cell and now I wish to increase the value to another 20% on the below table. Is there a way I highlight it an just x 120% A B C D E F G 1 1 9 2 2 6 5 6 2 3 5 4 6 2 21 24 3 5 21 56 4 14 6 24 4 7 2 69 59 9 4 86 5 9 9 7 2 5 88 35 6 10 4 8 5 2 2 7 7 45 5 1 9 10 6 59 8 19 3 5 58 6 7 1 9 20 8 6 6 97 2 4 10 5 8 2 2 69 39 7 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there away to shorten | Excel Worksheet Functions | |||
Can I shorten this any? | Excel Worksheet Functions | |||
Number in cell increase with increase in font size. | Excel Discussion (Misc queries) | |||
Any way to shorten this up? | Excel Worksheet Functions | |||
Shorten A Name | Excel Discussion (Misc queries) |