Incorrect Number Format

Giganews Newsgroups
Subject: Incorrect Number Format
Posted by:  John Chan (jo…@ms.com.hk)
Date: Tue, 14 Oct 2003

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

Replies