These solutions are far too complex especially if you have very large sheets.
Why not use the extension CT2N?
It is simple, very straightforward and you can decide ,whole sheet, or just
parts.
The ' is just removed.
I understand it is to be included as standard, in which case there will be
no need to install the extension.
You can find it here:
http://extensions.libreoffice.org/extension-center/ct2n-convert-text-to-number-and-dates


Tink.



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

-- 
To unsubscribe e-mail to: [email protected]
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

Reply via email to