Hey
How do a get a negitve number to be bracketted rather than showing the
quot;-quot; sign. I'm also using thousand seperators.
Cheers--
Embalmer
------------------------------------------------------------------------
Embalmer's Profile: www.excelforum.com/member.php...oamp;userid=17907
View this thread: www.excelforum.com/showthread...hreadid=497197lt;Formatgt; lt;Cellsgt; lt;Numbergt; tab,
And click on quot;Number' in the left window,
And on the right side you'll see a choice of 4 or 5 negative formats,
And also you can click on quot;1000quot; separators.
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
quot;Embalmerquot; gt; wrote in
message ...
gt;
gt; Hey
gt; How do a get a negitve number to be bracketted rather than showing the
gt; quot;-quot; sign. I'm also using thousand seperators.
gt;
gt; Cheers
gt;
gt;
gt; --
gt; Embalmer
gt; ------------------------------------------------------------------------
gt; Embalmer's Profile:
www.excelforum.com/member.php...oamp;userid=17907
gt; View this thread: www.excelforum.com/showthread...hreadid=497197
gt;Hi,
Select the cells --gt; quot;Formatquot; --gt; quot;Cellsquot; --gt; click on quot;Numberquot; Tab, select
quot;Numberquot;, check quot;Use 1000 separatorquot;, choose an appropriate format for
quot;Negative Numbersquot; --gt; quot;OKquot;
Regards,
B. R. Ramachandranquot;Embalmerquot; wrote:
gt;
gt; Hey
gt; How do a get a negitve number to be bracketted rather than showing the
gt; quot;-quot; sign. I'm also using thousand seperators.
gt;
gt; Cheers
gt;
gt;
gt; --
gt; Embalmer
gt; ------------------------------------------------------------------------
gt; Embalmer's Profile: www.excelforum.com/member.php...oamp;userid=17907
gt; View this thread: www.excelforum.com/showthread...hreadid=497197
gt;
gt;
- Aug 14 Mon 2006 20:09
Custom Number
close
全站熱搜
留言列表
發表留言