Remove apostrophe used for text formatted number in Libreoffice

To enter the number as text, the easiest way is to enter the number starting with an apostrophe (for example, ‘00008). The apostrophe will not appear in the cell, and the number will be formatted as text.

If apostrophe is not removed, calculation operations will not be include the cell & result will be wrong. So You may need to remove apostrophe or Formatting Numbers as Text or formatting mark or special non-displaying character to do calculate with this number.

To Convert text formated cells to numbers in libre-office, follow the below steps :

1. Choose Edit – Find & Replace
2. In the Search for box, enter ^[0-9]
3. In the Replace with box, enter &
4. Check Regular expressions
5. Click Replace All

Note: ^[0-9] regular expression means ‘other than 0-9 numericals’.