I download the file, and open in a text editor (Notepad? - I use TextPad). I then highlight the whole less the headings, and copy the highlighted material. I then open the spreadsheet bank statement file, and then paste. A dialogue comes up asking me how It wants the material dealt with. I make sure that the comma separated option is ticked. It is also convenient to set the other separator as single quote. I then OK and all is well. If that is not clear perhaps you could say what exactly you are doing.
Best wishes On 21 Aug 2012 at 11:51, William Smith wrote: Send reply to: [email protected] Date sent: Tue, 21 Aug 2012 11:51:36 -0400 Subject: Trouble with Open Office 3.4 Calc From: William Smith <[email protected]> To: [email protected] > Open Office 3.4 Calc turns the csv files I get from my bank into > unintelligible rubbish which, in turn, makes them unsuitable for > CSV2OFX. Earlier versions of Calc did not do this. My question is: > can I keep version 3.4 for the text, formula, presentation, etc. > functions and revert back to an earlier version of Open Office calc? > If so, how do I do this? > > WPS > Niall Martin Phone 0131 4678468 Please reply to: niall<at>rndmartin.cix.co.uk --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
