Incorrect Number Format

[John Chan]

Hi:

I try to set a cell format "Number" with negative
number display in a (1234.00) layout. Hoever, in Format
Cell, it shows negative number layout as
-1234.00(black)
-1234.00(red)
-1234.00(black)
-1234.00(red)

(1234.00) is replaced. I try to modify the format
in 'Custom' so that it layout looks like (1234.00). But
my Excel does not recognize it as a number format and the
negative number layout is shown as same as above.

What can I do???

Thanks

John

 

[Peo Sjoblom]

I am not sure what you mean, is this the format you are looking for?

0.00_);(0.00)

 

[John Chan]

Hi:

The format is 0.00_;-0.00. I try to modify it as
0.00_);(0.00). Excel can change the layout to (1234.00)
but my Excel does not recognize 0.00_);(0.00) as one of
the number formats.

Thanks

John

 

[Dave Peterson]

I think this is a windows setting:

In win98:
Windows Start Button|Settings|Control Panel|Regional settings Applet