[libreoffice-users] Re: Converting text to numbers

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 users+help@libreoffice.org
> 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 users+help@libreoffice.org
List archive: http://www.libreoffice.org/lists/users/
*** All posts to this list are publicly archived for eternity ***