Custom Number
 

Hey
How do a get a negitve number to be bracketted rather than showing the
"-" sign. I'm also using thousand seperators.

Cheers


--
Embalmer
------------------------------------------------------------------------
Embalmer's Profile: http://www.excelforum.com/member.php...o&userid=17907
View this thread: http://www.excelforum.com/showthread...hreadid=497197

Custom Number
 

<Format <Cells <Number tab,
And click on "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 "1000" separators.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Embalmer" wrote in
message ...

Hey
How do a get a negitve number to be bracketted rather than showing the
"-" sign. I'm also using thousand seperators.

Cheers


--
Embalmer
------------------------------------------------------------------------
Embalmer's Profile:
http://www.excelforum.com/member.php...o&userid=17907
View this thread: http://www.excelforum.com/showthread...hreadid=497197

Custom Number
 

Hi,

Select the cells -- "Format" -- "Cells" -- click on "Number" Tab, select
"Number", check "Use 1000 separator", choose an appropriate format for
"Negative Numbers" -- "OK"

Regards,
B. R. Ramachandran


"Embalmer" wrote:


Hey
How do a get a negitve number to be bracketted rather than showing the
"-" sign. I'm also using thousand seperators.

Cheers


--
Embalmer
------------------------------------------------------------------------
Embalmer's Profile: http://www.excelforum.com/member.php...o&userid=17907
View this thread: http://www.excelforum.com/showthread...hreadid=497197