[libreoffice-users] Converting text to numbers

[Arda Tunccekic <arda@duzen.com.tr>]

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 "Number", it 
doesn't convert. I can't use the values in any formula. How can I 
convert them to numbers? Is there a "quick convert" feature?

Excel can use those values in formulas, even if I don't convert and with 
trailing spaces..

Thank you

--
Unsubscribe instructions: E-mail to users+help@libreoffice.org
List archive: http://www.libreoffice.org/lists/users/
*** All posts to this list are publicly archived for eternity ***