Delete " ' " symbol in a cell

Hello everyone,

I´d like to know how can I delete this " ’ " in a cell. The cell appears like this (13:24:25). It´s a cell with hours. But when I click on the cell this is what is show ( '13:24:25 ). And I can´t make any sums.

Can you help me on this?

Thank you in advance.


Hi @edneco
better ask in our Q&A website


@edneco The feature you need is (confusingly) called 'Text to columns". See How do I convert "Text Numbers" created by opening a CSV Currency Column? - #8 by dbooth - English - Ask LibreOffice