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