Home > Technical > Remove apostrophe used for text formatted number in Libreoffice

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’.

Advertisements
  1. Tobbe
    May 7, 2014 at 12:07 AM

    Thank you! This was exactly what I needed! I had some dates in LibreOffice copied from the web that couldn’t be sorted because of the apostrophe.

    Great with this info for LibreOffice which btw is a very good program suite! 🙂

  2. Mike Baldwin
    August 7, 2014 at 9:58 PM

    Brilliant – well done and thanks

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: