[libreoffice-users] Re: CALC convert text to numbers

Brian

If you are using a Mac 10.9 then you can move a Tool Bar icon simply by
clicking on the gap to the right of the icon.
When the "object" frame appears, drag the fame to where you want the icon,
let go and the icon will move.

I use CT2N when I copy and paste from a web site and it works, with one
exception.
If the number is prefixed by a currency sign, CT2N does not work.
Cor very kindly gave me a solution.
In your Macros you will find CT2N
In the module Main Code, find function Check for Text in String.
There you can find the line,  'new in 1.2.0: allow for negative numbers:
-=45, (=40,)=41
     Elseif j=45 AND i=1 Then'
You can then insert before, or immediately after that line, 'Elseif j = 163
AND i = 1 Then ' allow for £'
(Ignore the ' at the beginning and the end of the insert.)
This also works, Many thanks, Cor.

Tink.



--
View this message in context: 
http://nabble.documentfoundation.org/CALC-convert-text-to-numbers-tp4082413p4082704.html
Sent from the Users mailing list archive at Nabble.com.

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted