Stefan Weigel wrote: > > 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. > > This only works if you remove the spaces first > BTW. Is there anywhere where I can find info on the Error Codes such as > 511, 502 and 522? > >> 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 *** > > Tink. -- View this message in context: http://nabble.documentfoundation.org/Converting-text-to-numbers-tp2032297p2032668.html Sent from the Users mailing list archive at Nabble.com.
-- 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 ***
