On 2024-05-19 09:39, David Long 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
Hi, David! Which "data" are you copying? Reports? Some stuff you highlighted in an account register and then copy/pasted? Other? If it's a report, export it as HTML from GnuCash, then open it in Excel. Yes, Excel will let you select an .htm or .html file in the File » Open dialog; you don't even have to fiddle with the file type box in that dialog because Excel considers .htm and .html as "Excel files". If it's an account register (or search results), in GC click File » Export and export in CSV format. (In Windows, remember to put ".csv" at the end of the filename you specify in the dialog; GC apparently doesn't do this automatically.) Excel will open CSV files, too; the easiest way is to double-click the file.. If it's something else, please give us more details of what you're trying to do. (Also please say which version number of GC, and which operating system and version -- it's always a good idea to mention those when asking for help.) I'm puzzled by your remark about the currency designation. Excel doesn't have a problem with my pasting an amount with a leading dollar sign ($). And if I recall correctly, there's also no problem with exporting a report that contains currency symbols -- again, the dollar sign is the only one I've tried. Maybe that's different in other currencies? Please give us more information about what you're doing and what error message you get. Stan Brown Tehachapi, CA, USA https://BrownMath.com _______________________________________________ gnucash-user mailing list [email protected] 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.
