Excel - please help

System
System Posts: 100,534 🤖 Admin 🤖
edited 10:09AM in AAT student discussion
hi,<BR><BR>i am trying to show minus numbers in Excel with brackets. i think i have to format the cell, perhaps in custom, but with what?<BR><BR>i am probably being blonde but i am stuck.

Comments

  • System
    System Posts: 100,534 🤖 Admin 🤖
    Excel - please help

    If you click onto the cell or cells and then go into format and click on Text and that will allow you to use brackets.<BR>
  • System
    System Posts: 100,534 🤖 Admin 🤖
    Excel - please help

    Only other manual way is to put a apostrophe in front of the bracket. Im sure there is a automatic way to do this, but seeing as I dont have access to excel at the moment, I can give you a better answer.
  • System
    System Posts: 100,534 🤖 Admin 🤖
    Excel - please help

    firstly format the cell as a number<BR><BR>then choose custom format and go down to the first format u find, select that and then type brackets infront and at the end... done it loads of times<BR>
  • System
    System Posts: 100,534 🤖 Admin 🤖
    Excel - please help

    is the first format '0' or what does it look like?
  • System
    System Posts: 100,534 🤖 Admin 🤖
    Excel - please help

    I would you '(-10,000) then format colour.
  • System
    System Posts: 100,534 🤖 Admin 🤖
    Excel - please help

    thanks alot guys, it worked!
  • System
    System Posts: 100,534 🤖 Admin 🤖
    Excel - please help

    You can use the following in format - cells - custom<BR><BR>0.00;[Red](0.00);0.00<BR><BR>It's in three sections each separated by a semi-colon<BR>the first is the format for positive values in the cell <BR>the second is for negative, in this case red with brackets round it <BR>the third is for zero which is optional but putting it in will prevent 0 being shown with brackets and in red which it sometimes is. <BR><BR>The format method is useful if you want the cell to automatically show the bracket formatting, it'll work when a function is in the cell that might return a positive or negative result.

Categories

Privacy Policy