Custom Number

[Embalmer]

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

Cheers

[Ragdyer]

<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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[B. R.Ramachandran]

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
>
>