I have a multiple of Spreadsheet Sheets, as a GraphPack, from the Grattan Institute in Australia.
But all the values are things like '92, '3.53 when you look at each cell. The file is a LongName.XLS.
It looks ok, as the table are meant for DISPLAY, not addition and substraction,
But I want to make a graph of the number, but Libre Calc doesn’t read the as numbers and
makes a blank graph as there are no “Numbers”
How does one convert Text to Number?
I would like to do a search and replace ALL (’) with blank or Null,
Or can a do a mass style change from '95.6 '72 to 95.6 72 with some function that i cannot find now.
And the only “book” I can find on Calc is for version 4.1. Surely there is a new manual.