Convert to Number

[smbhatt]

no option of Convert to No. From ’ in cell (character field).

[mariosv]

Please take a look to this thread.

Changing Text to numbers

I am new to Libre Office and am trying to import a csv file into a spreadsheet. Once imported, the dollar figures have a ’ in front which seems to mean that they are text not numbers. I have tried to change the formating but it does not seem to work. The help section does not seem to help as it only shows how to change numbers to text, not vice versa. Can anyone help as I really need to get these columns into number format. Thanks for any help. i have a large table with lots of zeros. a lo…

[horst]

In Calc there are two functions VALUE(text) and NUMBERVALUE that convert text as numbers to real numbers.