Highlight all the desired cells. Right click and select Format Cells. From
the Number tab you can select the desired view.

"allan" wrote:

In Excel 2000, "format cells accounting" got me brackets around negative
numbers. Excel 2003 gives me a negative sign. Is there any to change this?
I know I can get the format I want in custom, but this seems to require
formatting each cell.