Convert Text To Number (and date)

This extension doesn't seem to do anything. I can see it is installed but there is no new toolbar so I can't see how to use it.

OOC 4.1.1
CT2N 1.4

The download I got has all the "numbers" formatted like
'121.44
I used your extension but it just says "Nothing to change".
I have Windows 8 & OpenOffice.org 3.4.1.
A little help?

Works great on dates and numbers, however, my broker account down load is brought up in calc with both the apostrophe and dollar sign before the number ('$123.00), have I done something or is this one that the Convert Text To Number does not handle?

The conversion from text to number works fine if the text version is '123.45. It doesn't work if the text version is ' 123.45. If one manually removes the spaces between the ' and the first digit, the conversion will work fine. It would be nice to get a fixed version as many of the files I import have the numbers as text, with spaces between the ' and the start of the number.

Cline

Great tool that works perfectly with any string containing just the unwanted ' and numerals. But it ignores data that was originally a percentage -- numerals followed by % -- converted to text during export by adding the unwanted ' and resulting in the string '12.3%. Can this be converted from text by the correct setting of CT2N parameters, or does the presence of the % in the string cause CT2N to always ignore it?

Just purchased a new laptop with 64-bit Windows 7. Installed OpenOffice.org (new user) and was using Calc. I copied data from a website and pasted it in and had an issue with numbers coming in as text. Cell value shows just the number preceded with the single quote. This add-on seemed that it would be the perfect fix for me. Whether I select a single cell, a group of cells, or choose whole sheet, it indicates there is nothing to change.

Has this been verified for Windows 7 64-bit? Thanks!

Works just as described!

This worked great for me in converting large columns of dates imported as text to real dates for calc.

This worked great on my office pc but for some reason I get an 'Unknown Error' when using it on my laptop, any ideas? if it helps the laptop is a hp 6735s preloaded with Windows 7. Thanks

Hi,
Thank you so much for this extension !
Good luck to you

Hi,
Your extension is very usefully, because in Excel to convert text to number is very easy and it is very necessary to be easy in openoffice also.
My problem was with numbers in format engineering as: 1.80022846907377E-02 for example. This kind of numbers excel know to convert, but sCalc don't. It will be very good if this problem will be resolved in the future versions of extension, and maybe this extension will be included in future version of openoffice. Excuse me for my English, and good luck.

Silviu Berbinschi

I have just downloaded your extension Convert Text to Numbers Version 1.0.1 , and, find it very useful. I am using it with OpenOffice 2.4.0, and Windows.

Three comments, while using it in Calc:

1. Highlight Cells, colors -- when not checked ( unchecked ) . . . it still highlights ( Background Color ) the cells that are changed, even when NOT checked
2. Icon on Toolbar - with mouse over the Icon . . . in English Version it displays "Start" . . . perhaps it should display "Convert Text to Number" . . . or . . . something like that.
3. Would it be possible, in a future release, to also convert either / both a Date and / or Time from text to a number / value? For example, '2008-06-14 to a date, OR, '15:03 to a time?

Great job, please keep up the good work.

Sliderule

Hi, this is a great extension for OO. But is there any extension can use for column to text?

Hi!

I tried this extension on spreadsheet converted from Excel xls file with lot of this kind of numbers - '7,8. But nothing happened. Converter just select all content of the spreadsheet and prints message with empty list of edited cells. Ubuntu 7.10, openoffice.org 2.3.1. Am I doing something wrong?

Andis