[GNC] Reports to match Quicken

[rsbrux]

I had similar problems pasting HTML (from a website, not from GnuCash) into
Excel 2016, both because of the currency symbol and because of a mismatch
between the thousands separator and decimal symbol and those expected by
Excel.  I'll have to see if I can do better with LibreOffice.
Excel refused to accept simple reformatting of the cells as "Number" or
"Currency", so I used a combination of search & replace (to eliminate the
currency symbol) and "Text to Columns".  I found this reference helpful:
https://contextures.com/xlDataEntry03.html

>>
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