Convert text to number in Libre Calc
I have a spread sheet containing percentages which have a "'" prefix, e.g. "'18.93%". I can't therefore treat them as numbers.
Find and replace cannot find a single instance of "'", so I cannot convert them en masse. How can I automate this conversion?
Older answers to this topic no longer seem to work.
Implementing suggestion:
Am I doing something wrong?
Solution
LibreOffice ignores the initial single quote for all purposes other than forcing the cell value to be treated as text. That said, in LibreOffice 7.5.9 I was able to do a Find and Replace with:
- Regular expressions: on
- Find:
(\d+[.]\d+[%])(in parentheses to create a capturing group) - Replace:
$1(also=$1works)
- How to extract url from Google Sheet Cell with anchor text hyperlink
- How to convert a table to a list with row & column header
- Google Sheets Formula to Clean An Array of Data
- How to unnest data from one column to fit the entire dataset - Google Sheets
- How to get last number in a row on Google Spreadsheets
- Condition if-else
- Formula to grab values from another column and paste with dynamic offset
- How do I find the highest sum of multiple cells in column A where the sum is based on multiple cells matching in column B in Google Sheets?
- Google Sheets - select "most recent " cell in a column and return corresponding value in same row
- Drools 8 - Decision table with "in" constraint take only first one item
- How to Create a Button and Assign a Script to It Using Google Apps Script?
- Google Sheets formula to move and clean an array of data
- Ranking formula in Google Spreadsheet
- Google Sheets Transpose Formula
- Copy cell values to another worksheet based on cell value
- In Google sheets, how does one either return a blank cell or perform a function based on another cells lack of content?
- Download Google Docs From Links
- Datetime comparison query
- Automatic subtraction according to conditions in Google Sheets
- Filtering data from other google Spreadsheet sheet based on a combo value from other sheet in the same spreadsheet
- Google Sheets: SUMPRODUCT Formula for Summing Income and Expenses by Month Across Multiple Sheets
- Count value in cells above
- Using Lookup formula in URLs to match broad matches
- Combine two columns that's are on a column "B" and column "C" and then make them into one column on column "E" with even and odd position each others
- Finding the total numbers between values in TI nspire spreadsheets
- Pull records from a report and show them in drop down menu
- How do i check for & filter by multiple unique arguments in google sheets?
- Workbook "Calculation Options" stays in Manual no matter the operation (open, save, close) being performed unless approved user hits Calculate
- Turn table into a list
- Google Sheets - Difference of Two Columns With Duplicate Values