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
regards Renato use MMEX since 2009, now with Windows 11
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.
regards Renato use MMEX since 2009, now with Windows 11
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 1531 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 1531 times
Last edited by MartinArmstrong on Sun Dec 04, 2022 8:11 pm, edited 1 time in total.