The extension by Cor Nouws, CT2N, "Convert Text 2 Numbers" is ideal and quick. Paste, then click on the icon in the toolbar and it is done. Wherever there is a number prefixed by ' the ' will be removed. Nothing else will be changed and your sheet looks exactly the same. Here is the link http://extensions.libreoffice.org/extension-center/ct2n-convert-text-to-number-and-dates
-- View this message in context: http://nabble.documentfoundation.org/pasting-numbers-into-Calc-tp4049181p4049720.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@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