Am 08.04.2016 um 01:35 schrieb MR ZenWiz: > I recently began to use the spreadsheet downloads from one of my > credit unions as it is so far superior to the home-grown method I have > been using it's not even funny. > > (I know, way late... Cries of "luddite" in the background, etc.) > > 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. I don't see a way inside calc either to simply > convert that to a currency amount or to strip out the leading > apostrophe/quote mark that inhibits proper evaluation of the field.
Language = English(USA) [X] Detect Special Numbers -- 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
