How to remove leading apostrophes in number cells

LibreOfficeThe leading apostrophe sometimes present in a number cell, signifies that the cell is text formatted.  This article describes the process for removing it.


Open the spreadsheet file in LibreOffice Calc.

  1. Select the column of text formatted numbers that you want to tidy up.
  2. On the Main menu, go to Format > Cells.
  3. In the dialog box that appears, click Number, General and click OK.
  4. Go to Edit > Find & Replace.
  5. In the Search for box enter .* (period, asterisk).
  6. Enter & in the Replace field.
  7. Expand Other options.
    1. Enable Current selection only.
    2. Enable Regular expressions.
  8. Click Replace all.


Thanks for visiting,