formatting negative numbers - red and brackets

lezawang

Well-known Member
Joined
Mar 27, 2016
Messages
1,785
Office Version
  1. 2016
Platform
  1. Windows
Hi
I want to format negative numbers as red with brackets and with negative sign or not. I know I can custom format that but I also know I should be able to find that format under Format Cells --> Numbers. But I could not find that option in my Excel (please see screenshot link below). I went to my Windows 10 Settings (see the screenshot#2 link), I see the negative number and I can select the (1.1) but it is still grayed out. How to fix that? Thank you very much.

format1.PNG
format2.PNG
 

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

jtakw

Well-known Member
Joined
Jun 29, 2014
Messages
6,007
Office Version
  1. 2016
Platform
  1. Windows
Hi,

Try the "Currency" format with no $ sign (choose "none" for symbol)
 

lezawang

Well-known Member
Joined
Mar 27, 2016
Messages
1,785
Office Version
  1. 2016
Platform
  1. Windows
Thank you for your reply. Currency does not have ( ) for negative numbers as well. Please see below. I just tried it on other computer win7 and I have under negative numbers the ( ) format but not this win10 computer. Thank you very much
format3.PNG
 

jtakw

Well-known Member
Joined
Jun 29, 2014
Messages
6,007
Office Version
  1. 2016
Platform
  1. Windows
Mine does. May be it's a regional thing, don't know, and I'm on Win 10, Excel 2016

Screenshot (3).png
 

jtakw

Well-known Member
Joined
Jun 29, 2014
Messages
6,007
Office Version
  1. 2016
Platform
  1. Windows

ADVERTISEMENT

Here's an article that'll help you, you'll need to adjust some setting.

 
Solution

lezawang

Well-known Member
Joined
Mar 27, 2016
Messages
1,785
Office Version
  1. 2016
Platform
  1. Windows
Thank you very much. The link helped. I found that I need to change the number and currency both to ( ) for negative them excel will have that option. great help .. thanks a lot.
 

jtakw

Well-known Member
Joined
Jun 29, 2014
Messages
6,007
Office Version
  1. 2016
Platform
  1. Windows
You're welcome, thanks for the feedback.
 

Forum statistics

Threads
1,141,001
Messages
5,703,656
Members
421,308
Latest member
NewBlood

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top