Report export via HTML open by excel

[Paul Schwartz]

I use Libre Office and Open Office, and the same problem exists. My solution is to move the text entries to a different column and insert formulas [using the VALUE function] in the original place.

Doesn't take too long. :-)

HTH

Paul




>________________________________
> From: Dustin Henning <The00Dustin at gmx.net>
>To: 'Dodjie60' <dodjiel at fastmail.fm>; gnucash-user at gnucash.org 
>Sent: Thursday, July 26, 2012 6:26 AM
>Subject: RE: Report export via HTML open by excel
> 
>Dodje,
>    Have you at least checked to make sure they aren't already numbers,
>or do you have some reason to believe they are not?  In proper Excel 2003,
>it shows a mark in a corner when a number is stored as text, and that
>indicates you can click to convert to number.  If that is what you are using
>with the old version of GnuCash and the data from the new version doesn't
>have that mark, then it is already at least stored as a general cell, which
>can be handled the same way as a number.
>    Dustin
>
>-----Original Message-----
>From: gnucash-user-bounces+the00dustin=gmx.net at gnucash.org
>[mailto:gnucash-user-bounces+the00dustin=gmx.net at gnucash.org] On Behalf Of
>Dodjie60
>Sent: Thursday, July 26, 2012 08:04
>To: gnucash-user at gnucash.org
>Subject: RE: Report export via HTML open by excel
>
>Dustin Henning,
>
>Nope, I did not move to windows, I am using excel via crossover office
>(cxoffice) in Debian. I ask because I need the old versions option which
>when opened with excel could be converted to numbers. If I were to manually
>format the numbers (which as you know is a link to I don't know where) it
>will take me forever. 
>
>I again tried upgrading gnucash to the latest version with the same problem.
>
>
>Dodjie Lopez
>CPA #0076020
>Tycoon Animation Inc.
>OBI Construction
>PanAsia Films 
>
>
>
>--
>View this message in context:
>http://gnucash.1415818.n4.nabble.com/Report-export-via-HTML-open-by-excel-tp
>4655876p4655882.html
>Sent from the GnuCash - User mailing list archive at Nabble.com.
>_______________________________________________
>gnucash-user mailing list
>gnucash-user at gnucash.org
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>-----
>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 at gnucash.org
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>-----
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.
>
>