[GNC] Questions

[Stephen C. Camidge]

I used Libre Office and it worked. Thank you very much for the workaround!

Steve


-- 
Stephen C. Camidge             scamidge at 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 at 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.
>