Hi David When you paste into Calc (I'll assume you are using Ctrl-v), you should get an Import options screen pop up in which you can tick a box "Detect special numbers (such as dates). I find this works for me (using different versions of Linux on differing hardware) I hope that helps!
Cheers Hop On Sun, 14 Apr 2024, 11:54 am 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.
