A solution has been suggested by linl33. Worked like a charm.
Lin suggested that Autocorrect options can be changed to allow keying in of the correct single quote.
For the sake of completeness, I’m including a screenshot and the solution here -
In LibreOffice Calc, go to Tools > AutoCorrect Options… > Localized Options. In that tab, make the changes as shown in the screenshot below.
That did the trick for me.
Thanks everyone.
Cheers!