View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default how do i reflect a negative amount in brackets in excel?

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
...