I open csv files in notepad (actually textpad, which is better in various ways), then highlight the download, copy, then open my spreadsheet, where there are columns set for date, currency etc., so that I can paste it in at the point you choose. Up comes a dialogue. The important box to tick is the one that says the divider is a comma. You don't want tab here (csv is after all comma separated variable!) There is another that allow you to set single or double quotes. Experiment to see what works best (a box shows the effect) -- I set single quotes. Then hit the OK button.
That should do it. On 2 May 2012 at 10:25, Bill Dillinger wrote: Send reply to: [email protected] Date sent: Wed, 02 May 2012 10:25:54 -0400 From: Bill Dillinger <[email protected]> To: [email protected] Subject: OO spreadsheet question > When I download my bank statements they come as .csv files. When I > open these in the Open Office spreadsheet the fields with numbers come > in as characters and the formula window shows them to be preceded by > a quote, ', mark. I have looked through 'help' but have not found a > way > to remove the leading quote or to reformat the column to numbers so > they can be used in calculations. > > I would appreciate it if someone would tell me how to change these > columns of characters into numbers. > > 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]
