"sidm" <u38329@uwe wrote
I tried your method ,it does not work on my excel 2003 SP2.
It would have been simpler though.

I'm using xl2003, too

Wonder which part of my response doesn't work for you?:
Click Format Cells Number tab
Choose Number under "Category", set the dp to zero,
select the desired bracket format
from the list under "Negative numbers" OK

Over here, under "Negative numbers",
for the bracket format,
I can click to select either:
(1234)
(1234) [in red]
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---