Cell formats

  • Thread starter Thread starter steve
  • Start date Start date
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
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

changing signs in formulas and cells 1
Entering a time into excel 10
Formula help 4
how do i count cells with values in a certain range ? 3
Excel =SUM(A1=A1+B1) 0
Formula in a cell, keep the answer from going over a certain value 1
Number formatting 1
formatt 1

Back
Top