[libreoffice-users] Re: Converting text to numbers

Le 08/12/2010 11:24, Arda Tunccekic a écrit : Yes, that's a solution, thank you Sndl :-) In this case, the values are; -- A1(text) : "1.2 " A2(text) : "2.5 " B1(number) : =SUM(A1:A2) (it shows

[libreoffice-users] Re: Converting text to numbers

Le 07/12/2010 09:31, Arda Tunccekic a écrit : Hi , I have an auto generated xls file, and I have a column in it, which is defined as text. I have numbers in that column, with trailing spaces which look like ; "1.2 " "12.9 " "3.4 " When I right click to the column, choose "Format Cells" and "Nu