Is the answer to "Copy Paste Special"?Sent from my Galaxy
-------- Original message --------From: Martin Groenescheij
<mar...@groenescheij.com.INVALID> Date: 23/06/2023 18:03 (GMT+00:00) To:
Users <users@openoffice.apache.org> Cc: frank.ledb...@sky.com Subject: Re:
Spreadsheet 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. ‘123Simple way to check is to enter =VALUE(B1)*VALUE(C1)
---- On Fri, 23 Jun 2023 18:40:36 +0200
frank.ledb...@sky.com.INVALID<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