Is it possible to suppress the currency abbreviation in reports

Dr_B Member ✭✭
edited August 2022 in Reports (Mac)
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?


  • jacobs
    jacobs SuperUser, Mac Beta Beta
    edited July 2022
    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 1993
  • UKR
    UKR SuperUser ✭✭✭✭✭
    As a possible workaround ... can you change the "USD " currency symbol to "$" without a trailing space? Would that help?
  • Dr_B
    Dr_B Member ✭✭
    I can't find any setting that allows me to change the currency designator.
This discussion has been closed.