Hi,
the easiest way to fix this within a spreadsheet is to do a
search&replace with regular expressions option activated.
open the search&replace dialog using Ctrl+F and activate "regular
expression" within the "more options" part of that dialog.
search: .*
replace: &
This will remove all trailing single quotes from cells.
Kind regards, Joost
Am 26.06.2023 um 16:00 schrieb Martin Groenescheij:
Hi Frank, Please fix the Cells first.
Make sure all are formatted as Numbers and check that no value is preceded with
a apostrophe ' .
---- On Sat, 24 Jun 2023 18:22:15 +0200 <frank.ledb...@sky.com> wrote ---
Thank Martin, havn't tried it yet. I seem to take one step forward and two
back. Last time I tried to build this spreadsheet Im could do a multiplication
like A1*A2 then grab a symbols in the bottom right corner of the cell and drag
it down to get B1*B2 etc. Now I can't get the symbol.
Sorry to be pain in the proverbial
Frank
On Saturday, 24 June 2023 at 16:41:40 BST, Martin Groenescheij
<mailto:mar...@groenescheij.com> wrote:
=SUM(A1:A14) Not =SUM(A1;A14)
---- On Sat, 24 Jun 2023 12:10:33 +0200 <mailto:frank.ledb...@sky.com> wrote
---
Thanks Martin, moving on I am now having trouble summimg a column of numbers
(each being the result of a multiplication). In the formula bar Iwant to type
sum(A1;A8) but ~I am trying to chick on the cells A1 etc which puts the cell in
the formula but when I hit ; the whole formula is replaced with the colon.
Frank
On Friday, 23 June 2023 at 18:02:56 BST, Martin Groenescheij
<mailto:mar...@groenescheij.com> wrote:
Could it be that one ore both Cells is formatted as Text?
If you copy values from another source it could be copied as text which you
could check in the formula bar, it shows then with a leading apostrophe e.g.
‘123
Simple way to check is to enter =VALUE(B1)*VALUE(C1)
---- On Fri, 23 Jun 2023 18:40:36 +0200
mailto:frank.ledb...@sky.com.INVALID<mailto:frank.ledb...@sky.com.INVALID>
wrote ----
Having problem multiplying the values in two cella.I have tried =B1*C1 for
example but it doesn't workDisappointed as my attempt at division worked fine
on a previous worksheet using for example=A1/B1Please help if you canFrank
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org