If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Hi
In a blank cell type 1.15. Copy it (Ctrl+C). Select the range you wish to change and go to Edit|Paste|Paste Special|Multiply. Make sure you take a copy before you start! -- Andy. "Steve J" wrote in message ... Hi i have a speadsheet that has about 600 rows and 50 colums, and I need to increment all the numbers by 15%. I cannot for the life of me think how to do it - can somekind person help Tks S |
#2
|
|||
|
|||
Changing Numbers
Hi
i have a speadsheet that has about 600 rows and 50 colums, and I need to increment all the numbers by 15%. I cannot for the life of me think how to do it - can somekind person help Tks S |
#3
|
|||
|
|||
In a separate cell, enter 1.15, and copy
Select all of the other cells Goto EditPastespecial Click the Multiply button in the Operation section OK -- HTH Bob Phillips "Steve J" wrote in message ... Hi i have a speadsheet that has about 600 rows and 50 colums, and I need to increment all the numbers by 15%. I cannot for the life of me think how to do it - can somekind person help Tks S |
#4
|
|||
|
|||
Thanks people knew there wouild be an easy way !
"Steve J" wrote in message ... Hi i have a speadsheet that has about 600 rows and 50 colums, and I need to increment all the numbers by 15%. I cannot for the life of me think how to do it - can somekind person help Tks S |
#5
|
|||
|
|||
1. Place 1.15 in an open cell.
2. Copy that cell. 3. Select your range of data. 4. Press F5 Special. 5. Select "Constants" and uncheck everything except "Numbers" 6. Press OK. 7. Go to Edit Paste Special Multiply. Repeat the process if you have formulas that result in numbers. Start with step 5 but select "Formulas" instead. HTH Jason Atlanta, GA "Steve J" wrote: Hi i have a speadsheet that has about 600 rows and 50 colums, and I need to increment all the numbers by 15%. I cannot for the life of me think how to do it - can somekind person help Tks S |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
columns changing to numbers | Pablo | General Discussion | 2 | March 4th, 2005 11:59 PM |
Dissable outlook changing phone / fax numbers | Apples | Contacts | 1 | February 17th, 2005 11:16 PM |
Changing Page Numbers | Wood | General Discussion | 1 | August 14th, 2004 05:54 AM |