Hello,
You can convert the formulas to only keep the values by doing a
copy/paste special where what you will keep are only the numbers. To
do: select the cells, copy (CTRL-C or Edit > Copy) and then paste
special (Edit > Paste Special), and select to keep only the numbers.
You may be prompted to
Den lör 25 sep. 2021 kl 22:07 skrev Steve Edmonds <
steve.edmo...@ptglobal.com>:
> Hi Miss K.
> The purpose of your request is not clear.
> For the situation where I want to de-reference a value I use copy and
> then paste-special selecting only numbers.
> If you want 167 in A1 and 16.7 in A2 so
At 12:02 25/09/2021 -0400, Miss Keating wrote:
Is there a way to get LO (v5.2.7.2) calc to extract the numerical
value from a cell, and use that instead of the cell reference in
further calculations? Frinstance, if I have 167 in cell A1, and want
16.7 in A2, how can I program it, (if at all)?
Hi Miss K.
The purpose of your request is not clear.
For the situation where I want to de-reference a value I use copy and
then paste-special selecting only numbers.
If you want 167 in A1 and 16.7 in A2 so that is stays 16.7 even if A1
changes then possibly in B1 put =A1/10 then copy B1 and in
Do you have the following checked:
TOOLS -> OPTIONS -> LIBREOFFICE CALC -> VIEW
Value highlighting? If so, uncheck it.
Joe
On 9/25/21 11:08 AM, Dave Barton wrote:
Original Message
From: mxk [mailto:mxkeat...@comcast.net]
Sent: Saturday, September 25, 2021, 16:02 UTC
To:
Original Message
From: mxk [mailto:mxkeat...@comcast.net]
Sent: Saturday, September 25, 2021, 16:02 UTC
To: users@global.libreoffice.org
Subject: [libreoffice-users] extracting cell values
> Users Ahoy:
>
> Is there a way to get LO (v5.2.7.2) calc to extract the numerical
Users Ahoy:
Is there a way to get LO (v5.2.7.2) calc to extract the numerical value
from a cell, and use that instead of the cell reference in further
calculations?
Frinstance, if I have 167 in cell A1, and want 16.7 in A2, how can I
program it, (if at all)?
If I put =A1/10 into A2, A2
