India comma style in negative but in brackets

The below formula works in Indian format.
[>=10000000]#,##0,_;##\,#,#\,##,\,##0;[>=100000]##,###,#\,##,##0;##,##0

But If I want to put amount in negatives i.e. in brackets like (1,50,000) so
what is the method. Can you please help me out.
--
With warm regards,

Shri

Here's a Custom Format from Sweden:
[$€-2] # ##0,00_);[Red]([$€-2] # ##0,00)

HTH
Ola Sandström


Note:
Microsoft UK site - there is probably one for India
http://support.microsoft.com/?scid=k...d=1743&sid=340

This would not be solving the problems. I need the figures is in brackets
like (1,50,000). Can you please help the same.
--
With warm regards,

Shri


"olasa" wrote:

>
> Here's a Custom Format from Sweden:
> [$€-2] # ##0,00_);[Red]([$€-2] # ##0,00)
>
> HTH
> Ola Sandström
>
>
> Note:
> Microsoft UK site - there is probably one for India
> http://support.microsoft.com/?scid=k...d=1743&sid=340
>
>
> --
> olasa
> ------------------------------------------------------------------------
> olasa's Profile: http://www.excelforum.com/member.php...o&userid=17760
> View this thread: http://www.excelforum.com/showthread...hreadid=380287
>
>

Try:

##\,##\,##\,##0;[Red](##\,##\,##\,##0)


Mangesh



"shrinivas" <[email protected]> wrote in message
news:[email protected]...
> This would not be solving the problems. I need the figures is in
brackets
> like (1,50,000). Can you please help the same.
> --
> With warm regards,
>
> Shri
>
>
> "olasa" wrote:
>
> >
> > Here's a Custom Format from Sweden:
> > [$?-2] # ##0,00_);[Red]([$?-2] # ##0,00)
> >
> > HTH
> > Ola Sandström
> >
> >
> > Note:
> > Microsoft UK site - there is probably one for India
> > http://support.microsoft.com/?scid=k...d=1743&sid=340
> >
> >
> > --
> > olasa
> > ------------------------------------------------------------------------
> > olasa's Profile:
http://www.excelforum.com/member.php...o&userid=17760
> > View this thread:
http://www.excelforum.com/showthread...hreadid=380287
> >
> >

check this thread:

http://groups-beta.google.com/group/...ksheet.functio
ns/browse_thread/thread/d639c3f67cc5a5b2/f58c5e67139c1fd8?q=custom+format+in
dia&rnum=3&hl=en#f58c5e67139c1fd8


Mangesh



"Mangesh Yadav" <[email protected]> wrote in message
news:ekb8#[email protected]...
> Try:
>
> ##\,##\,##\,##0;[Red](##\,##\,##\,##0)
>
>
> Mangesh
>
>
>
> "shrinivas" <[email protected]> wrote in message
> news:[email protected]...
> > This would not be solving the problems. I need the figures is in
> brackets
> > like (1,50,000). Can you please help the same.
> > --
> > With warm regards,
> >
> > Shri
> >
> >
> > "olasa" wrote:
> >
> > >
> > > Here's a Custom Format from Sweden:
> > > [$?-2] # ##0,00_);[Red]([$?-2] # ##0,00)
> > >
> > > HTH
> > > Ola Sandström
> > >
> > >
> > > Note:
> > > Microsoft UK site - there is probably one for India
> > > http://support.microsoft.com/?scid=k...d=1743&sid=340
> > >
> > >
> > > --
> > > olasa
> >
> ------------------------------------------------------------------------
> > > olasa's Profile:
> http://www.excelforum.com/member.php...o&userid=17760
> > > View this thread:
> http://www.excelforum.com/showthread...hreadid=380287
> > >
> > >
>
>

and yet another:

http://groups-beta.google.com/group/...ksheet.functio
ns/browse_thread/thread/8eae769ceeb4e682/815a1ca9b4f6d783?q=custom+format+in
dia&rnum=1&hl=en#815a1ca9b4f6d783


Mangesh



"Mangesh Yadav" <[email protected]> wrote in message
news:ekb8#[email protected]...
> Try:
>
> ##\,##\,##\,##0;[Red](##\,##\,##\,##0)
>
>
> Mangesh
>
>
>
> "shrinivas" <[email protected]> wrote in message
> news:[email protected]...
> > This would not be solving the problems. I need the figures is in
> brackets
> > like (1,50,000). Can you please help the same.
> > --
> > With warm regards,
> >
> > Shri
> >
> >
> > "olasa" wrote:
> >
> > >
> > > Here's a Custom Format from Sweden:
> > > [$?-2] # ##0,00_);[Red]([$?-2] # ##0,00)
> > >
> > > HTH
> > > Ola Sandström
> > >
> > >
> > > Note:
> > > Microsoft UK site - there is probably one for India
> > > http://support.microsoft.com/?scid=k...d=1743&sid=340
> > >
> > >
> > > --
> > > olasa
> >
> ------------------------------------------------------------------------
> > > olasa's Profile:
> http://www.excelforum.com/member.php...o&userid=17760
> > > View this thread:
> http://www.excelforum.com/showthread...hreadid=380287
> > >
> > >
>
>