Negative numbers in parentheses

H

Hélène

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
 
S

scottymelloty

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
 
Top