Report amounts are text, not numbers

[Mike or Penny Novack]

satjat wrote:

>I am trying to export data from GnuCash to a usable format, say Excel.
>I only really need the transaction journal, maybe with some filters.
>I have a report exactly the way I want it but I have two major problems:
>1. The amounts listed are recognized as text by Excel so it is pretty much
>unusable
>2. Apart from being in text mode, the amounts are also hyperlinks to the
>transactions. That is not so serious but it would be nice if it could be
>solved since clicking tries to open a non existing file and pops up an
>error.
>Thank you all in advance
>  
>
If as described Open Office "calc" can open the file, then you can still 
use Excel if you prefer. Just use the Open Office to do the data 
conversion for you. Note that Open Office can be very useful for Excel 
users. MS is rather cavalier about things like making even versions of 
its own applications backward compatible. We had a devil of a time with 
Excel data collected over many years with the dates (data entered while 
using earlier versions) didn't show properly. A pass through (open and 
save) with Open Office fixed that.

Michael

-- 
There is no possibility of social justice on a dead planet except the equality of the grave.