Share via

Negative number to be displayed (-1.1), with minus sign and parentheses

Anonymous
2018-08-25T09:14:50+00:00

Dear community,

How do I set Win environment (excel) to display negative numbers with minus sign and parentheses?

Under Control panel only option is to change minus with brackets.

I want my number cells in excel to result instead of this GM = -1 - - 2 = this GM = (-1) - (-2) =

I have multiple sheets with text and numbers so formatting each cell by hand is nogo.

???

  1. On the Formats tab, click Additional settings at the bottom.
  2. On the Numbers tab, for Negative number format, choose (1.1)
Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

8 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Andreas Killer 144.1K Reputation points Volunteer Moderator
    2018-08-25T09:37:50+00:00

    Then my suggestion is the right one for you. You may not know how to apply it?

    Press CTRL-G

    Click Special

    Check Constants

    Uncheck all except Numbers (See screenshot below)

    Click Ok

    Note: At this point all cells why numbers are selected

    Press CTRL-1

    Apply the suggested format (See screenshot below)

    Andreas.

    1 person found this answer helpful.
    0 comments
  2. Vijay A. Verma 104.8K Reputation points Volunteer Moderator
    2018-08-25T09:20:42+00:00

    Unfortunately, Control Panel change will not provide the formatting which you are seeking. This doesn't provide you the option to create any other custom format. Whatever are there, they are fixed.

    1 person found this answer helpful.
    0 comments
  3. Andreas Killer 144.1K Reputation points Volunteer Moderator
    2018-08-25T09:27:46+00:00

    Sorry, I did not read your question correctly, please try this:

    General;"(-"General")"

    Andreas.

    0 comments
  4. Andreas Killer 144.1K Reputation points Volunteer Moderator
    2018-08-25T09:20:45+00:00

    Apply this number format to the cells:

    0;"-("0")"

    Andreas.

    0 comments