[libreoffice-users] Re: Converting text to numbers

Le 07/12/2010 09:31, Arda Tunccekic a écrit :
> 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
Imho the easiest way to convert text to numbers or numbers to text is to 
use Data -> Text to Columns.

You select you column (click the column header)
In menu Data -> Text to Columns
At the bottom of the wizard window, you select your column and change 
type to "Us English" .... And that's all folks !

Usually, this function is used to split one column to many ... but with 
only one colum it's really useful to make "inplace" type conversion



--
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 ***