| x404.co.uk http://www.x404.co.uk/forum/ |
|
| Quick Excel 2003 Question http://www.x404.co.uk/forum/viewtopic.php?f=4&t=4246 |
Page 1 of 1 |
| Author: | EddArmitage [ Mon Nov 16, 2009 3:11 pm ] |
| Post subject: | Quick Excel 2003 Question |
I have a column of floats in an Excel 2003 worksheet. I want to increase all of these values by a set amount (0.04). What's the easiest way to achieve this? |
|
| Author: | EddArmitage [ Mon Nov 16, 2009 3:25 pm ] |
| Post subject: | Re: Quick Excel 2003 Question |
Fixed by copying into a new worksheet, using a simple addition forumula, and then copying the values back in. Long-winded but avoids all the referencing... |
|
| Author: | EddArmitage [ Mon Nov 16, 2009 3:32 pm ] |
| Post subject: | Re: Quick Excel 2003 Question |
...maybe not. Any suggestions? |
|
| Author: | jonlumb [ Mon Nov 16, 2009 3:33 pm ] |
| Post subject: | Re: Quick Excel 2003 Question |
For future reference, you can use Copy + Paste Special using a column of 0.4 values, and select Add from under the options. Edit: You only need one 0.04 entry, not a column. |
|
| Author: | EddArmitage [ Mon Nov 16, 2009 3:50 pm ] |
| Post subject: | Re: Quick Excel 2003 Question |
Thanks Jon - worked a treat. |
|
| Page 1 of 1 | All times are UTC |
| Powered by phpBB® Forum Software © phpBB Group https://www.phpbb.com/ |
|