Hi :) Yes, as it happens. It would sweep up negatives in other columns and that might be a bonus. With a text-editor it's easier to remove the "s from around numbers too. A whole load of tidying-up can be done to convert non-standardised Csv files into something that works better in Calc or Excel or whatever.
Each of us has a different way of doing things and it's good to have such a wide range of choices so that we can do things in a fairly comfortable, or/and in a fairly familiar way or choose to learn new skills while doing something. OpenSource generally gives people freedom to choose their own way of doing things, and that can be seen as a negative or a positive. Regards from Tom :) On 14 Apr 2016 00:29, "Andreas Säger" <ville...@t-online.de> wrote: > Am 13.04.2016 um 12:32 schrieb Tom Davies: > > Hi :) > > CSV format can be easily edited in normal text-editors before opening in > > Calc. Sometimes its easier to use a simpler tool to do a part of the job > > rather than use a complicated route in a heavier tool such as Calc. > > Regards from > > Tom :) > > Really? And how do you convert (£1,234.98) into -1234.98 in columns 3, > 17 and 23 across thousands of rows using a text editor? Are YOU able to > do this actually? > Don't you think that checking "English(UK)" and "Interprete Special > Numbers" is by far easier? > > > -- > 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 > -- 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