Excel 2011 formating negative accounting ($100)

Discussion in 'Mac Apps and Mac App Store' started by LxHunter, Nov 11, 2014.

  1. LxHunter macrumors 6502

    Joined:
    Nov 14, 2010
    #1
    I cannot get excel to format negative accounting numbers as ($100).
    I used to have this option - but has disappeared from the format dialog.
    I tried switching Languages and Region from Canada to US and back and restart.
    But no luck.
    Google no help - driving me crazy

    Any ideas for a fix anyone?

    OSX 10.10
    Excel 2011 14.4.5
     

    Attached Files:

  2. campyguy macrumors 68040

    Joined:
    Mar 21, 2014
    Location:
    Portland / Seattle
    #2
    You're going crazy, but you're not nuts...

    MS seems to have fscked up more than a few long-standing things in its Mac-version office suite. One of the more-recent updates removed the formatting options you're looking for. FWIW, try out the following two Custom Formatting options that will get you where you need to go for now - it's what I'm using. Just copy the following text and paste it into the formatting field. For negative results the first gets you black text, the second gets you red results:

    $#,##0.00_);($#,##0.00)
    or
    $#,##0.00_);[Red]($#,##0.00)
     
  3. LxHunter thread starter macrumors 6502

    Joined:
    Nov 14, 2010
    #3
    Thanks campyguy
    That is the solution.
    Always surprised when basic features that have worked for 10+ years disappear.
     

Share This Page