Hello David, I do the same for my reports but paste it into Excel and whenever I had that issue I either use powerquery for the clean up or more quick and dirty approach of using functions to extract the correct figures, some MID/RIGHT function, within the CLEAN one wrapping the result and if you still have issues maybe using the VALUE formula to convert the final output (I would try this one first as it might work out with the previous ones)
In any case I think not all the reports cause the issue of being pasted as text, so maybe if you try to play with formatting options to number first and set those setting by default in the file it might help you. Thanking you. Regards, Inma On Sun, 14 Apr 2024 at 02:54, David Carlson <david.carlson....@gmail.com> wrote: > I have found that I can select the text of reports directly in GnuCash, > then paste it into a Libre Office Calc spreadsheet. The problem then is > that values are preceded with a dollar sign in the US and it seems that > they are not currency numbers but some form of text, as numeric operators > do not recognize them. It also looks like dates are in some form of text > as they have a format code "@" whatever that means. > > I am not very proficient with these format issues. Does someone know of an > elementary reference that is easier to understand than the spreadsheet help > file? > > Just in case it makes a difference I am using GnuCash release 4.8 in > Lubuntu 22.04 with a LXQT desktop. > > -- > David Carlson > _______________________________________________ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > 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@gnucash.org To update your subscription preferences or to unsubscribe: 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.
