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)
--
David Biddulph
"Rachel" wrote in message
...

Thank You.

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

"David Biddulph" wrote:

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)
--
David Biddulph
"Rachel" wrote in message
...

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

"Rachel" wrote in message
...
Thank You.

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

"David Biddulph" wrote:

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)
--
David Biddulph
"Rachel" wrote in message
...

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;@



Rachel wrote:

Thank You.

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

"David Biddulph" wrote:

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)
--
David Biddulph
"Rachel" wrote in message
...





--

Dave Peterson