I’ve converted an HTML table to ODS but all the numbers and dates have an apostrophe in front of them which only shows when a particular cell is highlighted. Is there a quick method of deleting the apostrophe in a column so that the numbers can be used in calculations?
Select the cells, choose menu Data - Text to Columns… - OK.
More LibreOffice Help on Text to Columns.
Tested with LibreOffice 6.4.7.2 (x86); OS: Windows 6.1.
Add Answer is reserved for solutions. If you think the answer is not satisfactory, add a comment below, or click edit (below your question) to add more information. Thanks.
Check the mark (
→ 
) to the left of the answer that solves your question.