Problems with decimal points when I export a Report
I moved from the US to Europe and I set my 2023 M2 Mac Mini, running Sequoia, Language and Region system setting to the European setting, change all my quickens accounts to “Euro” currency and the Number format in settings as “1 234 567,89”
All functions in Quicken operate properly, but exporting causes an unexpected issue.
If i export from the menu file → export → register to CSV) everything works fine
When exporting from a report (anyone), all numbers after the decimal symbol are lost. For instance, 1 609.03 becomes 1 603.
Can anyone help me?
Comments
-
Just a wild shot at a workaround: when you go to export the report, instead of selecting "Export to CSV file", see what happens if you select "Copy to Clipboard", open a blank spreadsheet, and Paste. Are the cents still lost?
Have you tried an alternate spreadsheet program (Numbers, Google Sheets, Excel) to see if the results are the same?
Or, probably the best place to start would be to open the .CSV file in TextEdit and look at the value to see if the cents are present or missing. If they're missing, it's clearly a Quicken bug.
Quicken Mac Subscription • Quicken user since 19930 -
"CSV" stands for Comma-separated values.
Looks to me like the comma in the amount acts as a field separator.
AFAIK, the numeric field would have to be enclosed in "quotes" or prepared in a pure numeric format with decimal point and without thousand separators and commas.
Or, try exporting the file as tab-delimited file.Somebody, maybe a Quicken programmer with more experience in properly formatting CSV values, would have to see what needs to be done when the computer is not using standard US/English numeric formats.
0 -
It's Quicken. All I had to do to reproduce the problem was change the number formatting in System Settings > General > Language & Region over to the European style being used by @alino ("1 234 567,89") and the exported report rounded off the fractional part of the number to the nearest integer.
A line from the exported report with European style numbers:
Total,,"-152"
The same line with US style numbers:
Total,,"-151.52"
1 -
There are four number formats in System Settings, and the one that uses spaces for the thousands separator and a common for the decimal point ("1 234 567,89") is the only one that Quicken rounds off when the report is exported. The other three numeric formats export the fractional part of the number.
0 -
If I select the "copy to clipboard" is the same, unfortunately
Number Sheets, Excel, Everything works in the same (bad) way
0 -
thanks, bug exporting as tab-delimited is not a option (at least for my quicken version)
0 -
Exactly as you mention, it's quicken after all, sometime strange things happens….
0 -
You can use Report a Problem to report this issue to Quicken; at best, it might be something they fix, but it's not likely to be quick. So…
• Can you live with exported reports which are rounded to the nearest Euro? (Most financial analysis doesn't really require seeing cents.)
• Can you live with changing your Mac to be of the other number formats which export reports properly?
• Can you live with printed reports, or printing to a PDF or opening in Preview?
Quicken Mac Subscription • Quicken user since 19930 -
Exactly as you mention, it's quicken after all, sometime strange things happens….
0 -
Thanks for your great help
It works!!!
0
