Removing currency from values

Paul Schwartz pmjs1115 at yahoo.com
Sun Aug 7 19:27:03 EDT 2011


I don't think it is easy to change the report formats; however, it is not hard to create numbers out of text in the spreadsheet program. that is what I do.

HTH

Paul




>________________________________
>From: James Wilde <james.wilde at sunde-wilde.com>
>To: gnucash-user at gnucash.org
>Sent: Sunday, August 7, 2011 2:32 AM
>Subject: Removing currency from values
>
>I'm running on a Mac (Lion) and the version is 2.4.7 (pre-lion build but with two fixes)
>
>I'm looking at custom reports, and loading an html file into LibreOffice calc.  The currency values appear as SEK 1,234.56 which to be sure is not strictly Swedish format, but that's a minor point.  The major point is that this is loaded into LibO calc as a text string, which means that it is left aligned, and even choosing right alignment doesn't really cut it.  I'd like calc to import these figures as numbers, without the currency code, SEK, and, now that I think of it, probably without the thousands and decimal separators, which should be left to the number formatting algorithm.  Is this possible, to produce reports where the values are merely numbers and not text strings?
>
>TIA
>
>James
>_______________________________________________
>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.
>
>
>


More information about the gnucash-user mailing list