|
View unanswered posts | View active topics
It is currently Tue May 06, 2025 10:03 am
|
Page 1 of 1
|
[ 5 posts ] |
|
Quick Excel 2003 Question
| Author |
Message |
|
EddArmitage
I haven't seen my friends in so long
Joined: Thu Apr 23, 2009 9:40 pm
Posts: 5288
Location: ln -s /London ~
|
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?
|
| Mon Nov 16, 2009 3:11 pm |
|
|
|
EddArmitage
I haven't seen my friends in so long
Joined: Thu Apr 23, 2009 9:40 pm
Posts: 5288
Location: ln -s /London ~
|
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...
|
| Mon Nov 16, 2009 3:25 pm |
|
|
|
EddArmitage
I haven't seen my friends in so long
Joined: Thu Apr 23, 2009 9:40 pm
Posts: 5288
Location: ln -s /London ~
|
...maybe not. Any suggestions?
|
| Mon Nov 16, 2009 3:32 pm |
|
|
|
jonlumb
Spends far too much time on here
Joined: Thu Apr 23, 2009 6:44 pm
Posts: 4141
Location: Exeter
|
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.
_________________
"The woman is a riddle inside a mystery wrapped in an enigma I've had sex with."
|
| Mon Nov 16, 2009 3:33 pm |
|
|
|
EddArmitage
I haven't seen my friends in so long
Joined: Thu Apr 23, 2009 9:40 pm
Posts: 5288
Location: ln -s /London ~
|
Thanks Jon - worked a treat.
|
| Mon Nov 16, 2009 3:50 pm |
|
|
|
|
Page 1 of 1
|
[ 5 posts ] |
|
Who is online |
Users browsing this forum: No registered users and 30 guests |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
|
|
