[GNC] Manipulating data extracted from gnucash to Excel

[Stan Brown (using GC 4.14)]

Open the report in Excel and _then_ do your copy and pasting. (You
probably want Edit » Paste Special » Values, keyboard Alt+E, S, V.)

Stan Brown
Tehachapi, CA, USA
https://BrownMath.com

On 2024-05-19 17:35, David Long wrote:
> Hi
> I mean copy paste from a gnucash  report.
> Rgds
> David
> 
> 
> On Mon, 20 May 2024, 04:13 Joseph Keithley, <joeyiii57 at gmail.com> wrote:
> 
>> Not sure what you mean by "copy".  In the Windows version of GnuCash 5.5
>> you can export your accounts to a csv file.  You pick the account, the date
>> range, and the separator (usually a comma).  There is also an option to
>> either add double quotes or not.
>>
>> On Sun, May 19, 2024 at 12:41 PM David Long <davidvernonlong at gmail.com>
>> wrote:
>>
>>> When I copy data from Gnucash to Excel it arrives on text format along
>>> with
>>> the currency denomination, so I cannot then manipulate it in Excel.
>>> Is there anyway I can export data to Excel in data format?.
>>> Thanks
>>> David
>>> _______________________________________________
>>> gnucash-user mailing list
>>> gnucash-user at 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.
>>>
>>
>>
>> --
>> iii
>>
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at 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.