Note: Unfortunately, the CTRL+c function does not work in the "All transactions" report, otherwise it would be possible to transfer the selected transactions to Excel in a simple way. See: https://github.com/moneymanagerex/money ... ssues/5394
Renato wrote: ↑Sun Dec 04, 2022 1:15 pm
Note: Unfortunately, the CTRL+c function does not work in the "All transactions" report, otherwise it would be possible to transfer the selected transactions to Excel in a simple way.
1. Go to the All Transactions view.
2. File | Export | HTML Files and save the file (xxx.html)
3. Open xxx.html in Excel, or just drag it into an open worksheet. You now have the transaction data, as you would have if you did copy/paste.
Hi @MartinArmstrong
thanks for the tip, but the amounts > 999.99 are displayed with a thousand delimitation "2 000 000.00" and Excel cannot calculate with that.
Renato wrote: ↑Sun Dec 04, 2022 4:09 pm
the amounts > 999.99 are displayed with a thousand delimitation "2 000 000.00" and Excel cannot calculate with that.
I don't have that problem because my thousands separator in Windows and in MMEX is a comma.
excel_cjoDozss90.png (54.88 KiB) Viewed 2667 times
If you want to use a space thousands separator in Excel (while keeping your Windows thousands separator in other applications), then in Excel:
- Click File > Options
- Click Advanced
- Under Editing Options, clear the check box Use system separators
- Click in the Thousands separator box
- Enter a space
- Click OK
ZWk11YhV3I.png (120.37 KiB) Viewed 2667 times
Last edited by MartinArmstrong on Sun Dec 04, 2022 8:11 pm, edited 1 time in total.
Renato wrote: ↑Sun Dec 04, 2022 4:09 pm
the amounts > 999.99 are displayed with a thousand delimitation "2 000 000.00" and Excel cannot calculate with that.
I don't have that problem because my thousands separator in Windows and in MMEX is a comma.
Hi - How did you get MMEX to use comma as thousands separator? That would help me a lot!