Preferred format to display negative currency (US English)?

  • Which would be the more readable way to format negative numbers:

    • -$99.99
    • ($99.99)
    • Some other format I haven't considered

    Details: Most of our user base has finance experience, but some have none at all. We don't deal with international currencies, and it's a web application so I don't know of anyway to get the user's system settings.

    Maybe color them red, so the negatives will stand out.

    Case study: I stumbled upon this question after looking up what my bank meant by my credit card balance, which reads ($10.00). I had no idea. I would've preferred it represent over payments with positive numbers, and debts with negative numbers. You know, the way numbers work in all other contexts :|

    I'm working for a major financial institution, and they have specifically requested the format of -$99.99 over ($99.99). Further, Excel supports this, why is POI failing to deliver standard functionality

    Given the type of responses that have been provided for this question, more details probably should be provided to avoid the ambiguity in the responses.

    @MichaelLai I was happy with the answers I got right after posting. But that was when the site was still in beta. You’re right, it has attracted a lot of extra answers that aren’t terribly helpful. This question is 10 years old. I don’t even remember which application this question was referencing. I’m not sure what more I could add to it. Could we lock the question instead?

  • My wife is a Certified General Accountant, so I asked her about this question.

    The standard accounting way is always to show negative numbers in parentheses. If you want to appeal to primarily financial professionals, that's the accepted practice.

    She also cautions against using red or drawing attention to a negative number. Highlighting a number necessarily draws attention to it, but negative numbers are a normal part of bookkeeping and financial statements. Unless you have a specific reason for drawing attention to a particular number, it's best not to make it stand out. If you're highlighting a number that is completely normal (even if it is negative), you can actually damage readability and usability. The user has to stop and think, why is this number different or special? At best, highlight situationally and only when it makes sense.

    VitiousiMedia's point about only showing the number in red when it's *not* suppose to be negative is very important and deserves credit for the answer. We'll evaluate each number individually to determine if negative is "normal" or not. We will also be using the "-$ (#.##)" format from Daniel's answer below. I'd give dual credit, but I don't know how.

    @Jared - I'd be very careful about formatting that way. If the majority of your userbase is composed of financial professionals, they won't like it and it could provide confusion as it's not how they're used to seeing negative numbers. I'd highly, highly recommend that you do user testing for this from a representative sample of your users. If you simply must have both, make how negative numbers are displayed an option that can be set and then choose parentheses as the default. If you use both parentheses and the negative sign, **all** of your users will be confused instead of just one subset.

    +1 to VirtuosiMedia for saying "ask your users" without actually saying it and +1 to his wife for throwing in some usability advice. :-)

    Fantastic answer that could only be given by someone with knowledge in the domain. Proves yet again that most answers on this site based purely on opinion aren't as good as just doing research.

    This is a case where it really matters what your target market is. If it's financial professionals, if they see any other format than (##.##), they'll hesitate using the app because they'll perceive it as being consumer-oriented, not business-focused. They may also question how other areas of your app meet their needs. If your market is people with little or no financial or business experience, it might be better to have the negative sign as the parenthesis could give them the impression that it is too complicated. Either is fine, but there is no substitute for knowing your market.

    I own a Mac, and I couldn't find a way to use parentheses option in number format, I used the following custom format: `#.##0,00;(#.##0,00)`

License under CC-BY-SA with attribution

Content dated before 7/24/2021 11:53 AM