Re: [libreoffice-users] Converting text to numbers

Hi Cor,

I think it did not work.

You can try it yourself.

- Open up a new spreadsheet. Choose Column A, right click on it and 
click on Format Cells. Make them Text.
- Now type  "1.22    " , "2.4      ",  "3.51      "   in the first 3 rows.
- Go to Column B, select the first cell, click on the sum function 
symbol and choose the values on column A.

It doesn't calculate..
Nothing changes when I use the "Convert text to number" extension.

Maybe the extension can first trim the trailing spaces, and then change 
the cell formatting to number, if it can be done..

Thank you







On 07.12.2010 13:18, Cor Nouws wrote:
> Hi Arda,
>
> Arda Tunccekic wrote (07-12-10 09:31)
>
> > 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?
>
> The extension CT2N does help in many cases.
> You may want to try it:
>   http://extensions.services.openoffice.org/project/CT2N
>
> (And if it does not work, pls let me know. Sometimes I make some 
> changes, thus your situation might be covered by a future version.)
>
> Regards,
> Cor

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