Re: [libreoffice-users] Converting text to numbers

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