Is there a quick way to use the numbers in a HTML table converted to ODS?

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 (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 (Answer markCorrect answer mark) to the left of the answer that solves your question.