Report export via HTML open by excel

[Dustin Henning]

Dodje,
	This is what I was trying to describe, and as such, what I expected
to see when you posted images (except the php currency marker, but if your
system knows that is a currency marker, it should be fine).  Cells are
general by default unless they are somehow set as something else.  IOW, it
is good that they aren't "stored as text."  Why do you want them to be
stored as numbers?  If you are using formulas, have you tried to use those
formulas since the warning about them being "stored as text" isn't there?
If you haven't, you should, because they may be recognized as numbers
automatically in general.  If you have and they don't work, click on the
column header (C in this case), then right click on any highlighted cell,
and choose number (or currency) instead of general.  This should change them
all at once.  If it doesn't, then what you are getting out of GnuCash may be
the cause.  If you are pasting into Excel, you can also click the button
that pops up after you paste and choose "use text import wizard" if it is
available.  From that wizard, you might be able to get what you want by
splitting the php into a separate cell or something.
	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: Friday, July 27, 2012 03:40
To: gnucash-user at gnucash.org
Subject: Re: Report export via HTML open by excel

Paul,

Attached 2 image as stated problem. First using the new version and the old
version.

http://gnucash.1415818.n4.nabble.com/file/n4655898/02_PM.png 

http://gnucash.1415818.n4.nabble.com/file/n4655898/40_PM.png 



-----
The almighty dollar says that 'IN GOD WE TRUST".
--
View this message in context:
http://gnucash.1415818.n4.nabble.com/Report-export-via-HTML-open-by-excel-tp
4655876p4655898.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.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/x-pkcs7-signature
Size: 6578 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20120727/803e5007/attachment.bin>