[libreoffice-users] Re: Calc method to change whole column cell content

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: users+unsubscribe@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