currency vs accounting
Results 1 to 2 of 2

Thread: currency vs accounting

  1. #1
    Board Regular
    Join Date
    Mar 2016
    Post Thanks / Like
    5 Post(s)
    0 Thread(s)

    Default currency vs accounting

    I wanted to know the difference between currency and accounting number formatting. Excel easy website is saying this:

    "Note: the Currency format can display negative numbers with a minus sign, in red, with parentheses, or in red with parentheses. The Accounting format displays negative numbers in parentheses."

    I formatted 2 cells one as currency and one as accounting, when I entered -100, none of them changed the color to red or added ( )

    Thanks you so much

    Last edited by lezawang; Jan 8th, 2019 at 03:36 PM.

  2. #2
    Board Regular Norie's Avatar
    Join Date
    Apr 2004
    Stirling, Scotland
    Post Thanks / Like
    60 Post(s)
    6 Thread(s)

    Default Re: currency vs accounting

    If you open the Format... dialog you'll see that there are several options on how to display negative numbers in the Currency category.

    As for how the Accounting format displays negative values, perhaps that's dependent on locale.
    If posting code please use code tags.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts