I used Libre Office and it worked. Thank you very much for the workaround! Steve
-- Stephen C. Camidge scami...@fastmail.fm (519) 363-3912 On Wed, May 8, 2019, at 8:55 AM, Maf. King wrote: > 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. > _______________________________________________ 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.
