Incorrect Number Format

  • Thread starter Thread starter John Chan
  • Start date Start date
J

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
 
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
 
I think this is a windows setting:

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