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 get a bill to populate with the amount, only if the particular payday falls exactly on or 6 days before the due date?
- Google Apps Script is not exporting PDF blob correctly
- Google Sheets - Bypassing the restriction of 50k characters for TEXTJOIN
- How to import Excel file into mysql database using phpmyadmin
- Excel VBA code to select non empty cells
- How to aggregate multiple transactions to show complete trades in one row in Google Sheets?
- Populate an Array with Column Numbers that Correspond to a Set of Strings
- Excel: Assigning 1/0 to True/False
- Google Docs - Convert date into day of the year
- how copy specific cells from one worksheet to another, on varying rows with spaces. Somehow use index match?
- Using VLOOKUP and COUNTIFS to tabulate data in a Google Sheet
- How can I use COUNTIF and FILTER functions to get a count for the output array?
- Google Scripts Returning Not a Number
- How do I calculate the daily average of 2 different items each day, over the course of time?
- Preventing or removing multiple instances of same range protected cells
- Calculate number of months, with various situations
- Formatting the data from a FILTER function
- Issue with QUERY command due to married and maiden names
- How to select a cell and get values in Fortune Sheet React | SpreadSheet
- Repeat rows in Google Spreadsheet based on a cell value (BUT repeated rows must be 7 days apart)
- ERR_OSSL_UNSUPPORTED when trying to use google spreadsheet library with typscript
- How to insert line break within OPENXML spreadsheet cell?
- IFS formula for greater than equal to but less than
- Text value in Sumifs / DATEVALUE
- Query between two dates
- First 10 characters from a column in a query
- How to copy a row of values from one sheet to another in one cell click?
- Submit module to save entries from 1 sheet to another sheet
- How to highlight a row by looping column values via conditional formatting
- Excel Index+ match Returns duplicate value