how to convert text to currency [closed]
in LibreCalc 4.2.7.2 I have many pages and columns of spreadsheet values using "currency-as-text" (all entries preceded by single quote) How do I convert these text entries to actual currency (leading single quote removed)? The format dialog options allow me to select the cell(s) but nothing happens when I ok the change to currency.
Closed for the following reason
the question is answered, right answer was accepted by
Alex Kemp
close date 2020-08-17 17:30:02.780599
add a comment
