Negative numbers in parentheses

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Good day,

Could someone help me with this: when numbers are negative, we prefer that
they appear in parentheses. Is there any way to do this and still keep the
numbers aligned in the column?

Thank you.

Hélène
 
Right click on the number and select "FORMAT CELLS"

Click on Custom

is should look something like this 0_;[Red]-0

change it to this 0_;([Red]-0)

they should be now in bracket
 

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

Excel 2007 - display negative numbers with minus sign and parenthe 3
Negative Numbers in Parentheses 2
Red cell for negative numbers in Excel 1
Negative Numbers 10
Displaying negative values in parentheses 3
displaying numbers in parentheses 2
Negative numbers parentheses 12
How do I align numbers in different cells when some are in bracke. 2

Back
Top