Does Excel have a format for this?
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: www.excelforum.com/member.php...oamp;userid=27107
View this thread: www.excelforum.com/showthread...hreadid=506743Thanks Dav. I'm new and you and Bernard have opened a new door in Excel for
me.
quot;Davquot; wrote:
gt;
gt; No,
gt;
gt; But it is very easy to create, go to the custom category under number
gt; tab when u format cells. Create your own format
gt;
gt; #,##0;(#,##0) if you just want brackets
gt;
gt; #,##0;-(#,##0) if you want a minus outside the brackets
gt;
gt; #,##0;(-#,##0) if you want a minus inside the brackets
gt;
gt; Dav
gt;
gt;
gt; --
gt; Dav
gt; ------------------------------------------------------------------------
gt; Dav's Profile: www.excelforum.com/member.php...oamp;userid=27107
gt; View this thread: www.excelforum.com/showthread...hreadid=506743
gt;
gt;
- Apr 21 Sat 2007 20:37
Brackets or paranthesis around negative numbers in Excel
close
全站熱搜
留言列表
發表留言