So after some experimentation I've hit upon an easy fix for importing CSV files with numbers ... changing the text delimiter to ' and selecting "Quoted field as text" and "Detect special numbers" does the trick. Of course you have to save the file before you can SUM or do anything else.
The nice thing is once you change these settings once they become the default setting. -- View this message in context: http://nabble.documentfoundation.org/sum-function-in-libreoffice-calc-doesn-t-seem-to-work-tp1839208p3478365.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions 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
