| View previous topic :: View next topic |
| Author |
Message |
Ljack
Newbie
Joined: 10 Feb 2009
Posts: 3
|
 Posted: Tue Feb 10, 2009 2:50 pm Post subject: value from formula |
 |
|
I have two columns of numbers in a spread sheet
I create a 3rd column in which the formula is =a2*b2 in row 2, =a3*b3 in row 3, etc.
I want to convert all of column c to numbers and delete column b
This is an embarrassing question because I managed to do it two weeks ago, and despite searching all available menus I cannot determine how I did it
_________________
ljack |
|
| Back to top |
|
 |
Robert Tucker
Moderator
Joined: 16 Aug 2004
Posts: 3367
Location: Manchester UK
|
|
| Back to top |
|
|
Robert Tucker
Moderator
Joined: 16 Aug 2004
Posts: 3367
Location: Manchester UK
|
| Posted: Tue Feb 10, 2009 3:33 pm Post subject: Re: value from formula |
|
|
| Ljack wrote: | I have two columns of numbers in a spread sheet
I create a 3rd column in which the formula is =a2*b2 in row 2, =a3*b3 in row 3, etc.
I want to convert all of column c to numbers and delete column b |
Put a1*b1 as the formula for c1 (or whichever row you start on). Left click on the little box at the bottom right-hand corner of c1 (you get a cross pointer). Holding the left mouse button down drag it down column c as far as your list of numbers goes.
_________________
LibreOffice 3.6.6 on Fedora 18, LibreOffice 4.0.2 on Ubuntu 13.04 (Double Boot) |
|
| Back to top |
|
|
Ljack
Newbie
Joined: 10 Feb 2009
Posts: 3
|
| Posted: Tue Feb 10, 2009 4:04 pm Post subject: |
|
|
My explanation didn't get all the way to the answer.
What I'm looking for is a way to convert those formula numbers to real numbers
As long as the formula is present, deleting column b leaves a whole string of #NAME? rather than the number
Thanks for the tip about dragging the cell corner. That is a lot more convenient than copy and paste
_________________
ljack |
|
| Back to top |
|
|
Ljack
Newbie
Joined: 10 Feb 2009
Posts: 3
|
| Posted: Tue Feb 10, 2009 4:19 pm Post subject: |
|
|
My embarrassment multiplies. I just discovered the way to do it, again.
> mark the column containing formulas
> edit, copy, edit, paste special, select numbers
_________________
ljack |
|
| Back to top |
|
|
|
