[GNC] Reports to match Quicken

[Adrien Monteleone]

The Transaction Report can produce various totals, including by account.

But after you paste into a spreadsheet, you can strip the currency symbols with a find/replace. If that doesn’t change those cells to number, you could change the format on them. Most spreadsheets also have a function to convert strings of numbers to numbers as well.

I’ve never experienced any problem with the currency symbols myself, however. (I use both Libreoffice and Apple Numbers) If you get a dialog when you paste, make sure the option to ‘detect special numbers’ is checked if it is available.

Regards,
Adrien

> On Aug 17, 2019, at 3:50 PM, Graham <graham.balin at gmail.com> wrote:
> 
> On 17/08/2019 19:50, Adrien Monteleone wrote:
>> That looks like what you can get out of a Transaction Report.
>> 
>> Regards,
>> Adrien
> 
> 
> Thanks, but the export of a transaction report seems to be pdf or html only, and if I cut and paste into a spreadsheet, the values seem to come out as a string, like
> 
> $26.75
> 
> and using the Sum function gives a zero total
> 
> --
> Cheerio,
> 
> Graham