[GNC] Questions

[Maf. King]

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.