On Wednesday, 8 May 2019 12:33:34 BST Stephen C. Camidge wrote: > I tried that. I added an autosum command totalling a column with a result of > $0 (wrong total). It is like it treats the cell as text. I tried opening > with excels' Data buttons for From HTML and From Text - still no success. > > On Wednesday, 8 May 2019 12:13:05 BST Stephen C. Camidge wrote: > > > Thank you to both of you. I have not figured out how to export to a > > > spreadsheet - I tried but only could export to html, added a sum of the > > > column, but the sum gave a total of $0. > >
Sorry, yes. Forgot a step. the HTML has £123.45 in the cells. Libre Office imports these as text. Doing a Find and Replace on the whole sheet and replacing £ with <nothing> works in Libre Office. Hope Excel is similar. HTH, Maf. _______________________________________________ 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.
