Brackets or paranthesis around negative numbers in Excel

[Lorne]

Does Excel have a format for this?

[Dav]

No,

But it is very easy to create, go to the custom category under number tab when u format cells. Create your own format

#,##0;(#,##0) if you just want brackets

#,##0;-(#,##0) if you want a minus outside the brackets

#,##0;(-#,##0) if you want a minus inside the brackets

Dav

[Lorne]

Thanks Dav. I'm new and you and Bernard have opened a new door in Excel for
me.

"Dav" wrote:

>
> No,
>
> But it is very easy to create, go to the custom category under number
> tab when u format cells. Create your own format
>
> #,##0;(#,##0) if you just want brackets
>
> #,##0;-(#,##0) if you want a minus outside the brackets
>
> #,##0;(-#,##0) if you want a minus inside the brackets
>
> Dav
>
>
> --
> Dav
> ------------------------------------------------------------------------
> Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
> View this thread: http://www.excelforum.com/showthread...hreadid=506743
>
>