On Mon, 2016-12-19 at 20:54 -0500, Jack wrote: > I'm starting to do some tax planning work, and I just discovered that > in exported reports, even the amount columns are ouput in quotes. This > makes is difficult to do calculations on them. (I use various > spreadsheet functions to take different cuts of various accounts and > categories.) I looked in my spreadsheet from last year, and apparently > I found some way to convert, but I don't remember whether I simply did > it manually (unlikely) or managed to play with the import process. Is > there any easy way to avoid the quotes around values that really should > be numbers, and so not forced to text? (this is in the export files > for reports) > > Jack
Hi Jack I export my reports (with quotes) to a csv file and then open directly in Libre Office Calc with "Text delimiter" option set as " and separator as Comma. You can then change the text to numbers with the Format option in Calc if necessary. Regards Timothy
