Cell formats

S

steve

Is it possible to customise a cell in excel that will
display a negative number within parenthesis rather than
the entered value preceeded by a minus sign?

e.g Value entry "-1500" displays as "-1500"

Required display "(1500)"

Regards
Steve
 
E

Earl Kiosterud

Steve,

Yes. Format - Cells - Number. In Category, choose Number or Currency, and
you'll have a box to choose the display format of negative numbers. For
more control, see Custom.
 
Top