Max wrote:
Click Format Cells Custom and type #,##0;(#,# # 0) in Type..Press OK
and
that's done.

Is the above preferable to the simple menu command in Format Cells for the
OP's purpose here, I wonder ?
I tried your method ,it does not work on my excel 2003 SP2.It would have been
simpler though.