Hi Arda, Am 07.12.2010 09:31, schrieb Arda Tunccekic:
> 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. Yes. The type of your data is text. If you change the format, the data type is still text. Try the VALUE() function in order to convert text into numbers. > Excel can use those values in formulas, even if I don't convert and > with trailing spaces.. Excel does an implicit conversion of data type, which can be an advantage or a disandvantage, depending on the point of view. Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- Unsubscribe instructions: E-mail to [email protected] List archive: http://www.libreoffice.org/lists/users/ *** All posts to this list are publicly archived for eternity ***
