Help! I can't get negative values in brackets to show in number format 1

[panini]

In format > cells > number, I only get

1234.00
-1234.00
-1234.00
-1234.00

and no brackets....

please help!

 

[Hasit]

The format cells standard offering does not offer brackets around negative numbers. You have to create your own custom format.

So, under FORMAT -> CELLS, select CUSTOM and type in the following:

#,###.00_);(-#,###.00);0.00

What the above shows is:

#,###.00 <- the format for a positive number
(-#,###.00) <- the format for a negative number (if you don't want a minus sign in front of the negative number, then just remove it)
0.00 <- shows the format of all numbers, i.e. that there are 2 decimal points after the integer.

 

[panini]

Thanks Hasit....

...but the other two machines I have show the format with brackets??

like...

1234.00
-1234.00
(1234.00)
(1234.00)

 

[Hasit]

What have the cells that show the brackets been formatted as?

You may want to copy that format over. Having said that, do you need to have two notations for a negative number (i.e. -1234.00 and (1234.00))??

 

[panini]

The cells that show the brackets have the format selected as...

1234.00
-1234.00
(1234.00) < this one
(1234.00)

This is not an option on the other users pc.... the only difference I can see is that the ones it works on are NT4.0 and the one it doen't is 2000 Pro....

 

[Hasit]

OK. I understand now. This is likely to be a machine setup difference. Heres how to fix it:

1. Click Start, point to Settings, and click Control Panel.

2. In Control Panel, double-click the Regional Settings icon.

3. Click the Currency tab.

4. In the Negative Currency Format list, select a format with parentheses and no spaces in the format and click OK. (The formats with the spaces do not correct the problem.)

 

[Hasit]

Oops. I submitted before I finished. You should make the changes as above on the machine you wish to show negative numbers with brackets

 

[panini]

Thanks for all your help Hasit!!!