If you would read the initial posts of the topics you are replying to ... MRZenwiz: > What I've been doing is loading the .csv file into a text editor, > change those fields and then reload into calc. This is terribly > cumbersome.
> However, in the .csv file they send, the dollar transactions are all > given as text entries with ($xxx.xx) for negative entries and $xxx.xx > for positive entries. which is perfectly well handled by Calc's csv importer. 90% of all text import trouble can be answered with: 1. Choose the right locale which is English(USA) in this particular case because of the $ currency, the point decimals and propably there are also M/D/Y dates in the file. 2. Always check "interprete special numbers". A special number is anything beyond digits with decimal separator. This option is obsolete since it should be always on. You can mark individual columns as text when you do not want them to be interpreted as special numbers. But once the option has been checked it remains checked for subsequent csv imports. -- To unsubscribe e-mail to: users+unsubscr...@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
