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.ba...@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 _______________________________________________ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
