Is it possible to suppress the currency abbreviation in reports
Dr_B
Quicken Mac Subscription Member ✭✭
Is it possible to suppress the 'USD x{A0}' preceding the numeric amount in reports? IN this case, x{A0} is the hex code for a non-breaking space.
I have some foreign currency accounts in a Quicken Mac file but I am not including them in my report. The report embeds USD followed by a space (actually x{A0} a non-breaking space) in the formatted Amount column. When I export as a csv file Excel is not happy with the USD and non-breaking space, i.e. it doesn't see them as numbers. I'm in the habit of using BBEdit to modify Quicken output but the introduction of the non-breaking space adds extra work when I go to delete all the 'USD x{A0}'.
I just want numbers in my report in the Amount field. Can this be done somehow?
I have some foreign currency accounts in a Quicken Mac file but I am not including them in my report. The report embeds USD followed by a space (actually x{A0} a non-breaking space) in the formatted Amount column. When I export as a csv file Excel is not happy with the USD and non-breaking space, i.e. it doesn't see them as numbers. I'm in the habit of using BBEdit to modify Quicken output but the introduction of the non-breaking space adds extra work when I go to delete all the 'USD x{A0}'.
I just want numbers in my report in the Amount field. Can this be done somehow?
Tagged:
0
Answers
-
No, there is no formatting of amounts in reports. Perhaps this should be turned into an Idea request? I've seen a similar complaint from a Canadian user recently. Only people who use multiple currencies will run into this problem, which is likely why it doesn't come up on this forum too often.Quicken Mac Subscription • Quicken user since 19930
-
As a possible workaround ... can you change the "USD " currency symbol to "$" without a trailing space? Would that help?
0 -
I can't find any setting that allows me to change the currency designator.0
This discussion has been closed.