how do i reflect a negative amount in brackets in excel?

[David Biddulph]

If you want to ask a question, please do so in the body of the message, not
just in the subject line. Blank messages will often be rejected or ignored.

If your question is that you have negative numbers and you want to know how
to format the cells to show the negative numbers in brackets, rather than
with a minus sign in front, then one option through Custom formatting is:
General;(General)

 

[Rachel]

Thank You.

Also, how would i reflect that number eith decimals?. ie. (123 000,00)

If you want to ask a question, please do so in the body of the message, not
just in the subject line. Blank messages will often be rejected or ignored.

If your question is that you have negative numbers and you want to know how
to format the cells to show the negative numbers in brackets, rather than
with a minus sign in front, then one option through Custom formatting is:
General;(General)

[/QUOTE]

 

[David Biddulph]

Use whatever format you would otherwise have used, & modify it by using
brackets instead of the minus sign in the format statement, for example:
# ##0.00;(# ##0.00)
--
David Biddulph

Thank You.

Also, how would i reflect that number eith decimals?. ie. (123 000,00)

[/QUOTE]

 

[Dave Peterson]

You really want spaces for the thousands separator?

For me (with my USA dot decimal point):
format|Cells|number tab|custom category
### ### ##0.00;(### ### ##0.00);0;@
positive;negative;0;text

I would think that you'd have to replace the dots with commas in that string:
### ### ##0,00;(### ### ##0,00);0;@

Thank You.

Also, how would i reflect that number eith decimals?. ie. (123 000,00)

[/QUOTE]