Re: Spreadsheet

2023-06-23 Thread alannpearce
Is the answer to "Copy Paste Special"?Sent from my Galaxy Original message From: Martin Groenescheij Date: 23/06/2023 18:03 (GMT+00:00) To: Users Cc: frank.ledb...@sky.com Subject: Re: Spreadsheet             Could it be that one ore both Cells is formatted

Re: Spreadsheet

2023-06-23 Thread Martin Groenescheij
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

Spreadsheet

2023-06-23 Thread frank.ledb...@sky.com.INVALID
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