Brackets or paranthesis around negative numbers in Excel
 

Does Excel have a format for this?

Brackets or paranthesis around negative numbers in Excel
 

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

Brackets or paranthesis around negative numbers in Excel
 

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