India comma style in negative but in brackets

[shrinivas]

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.

 

[olasa]

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=kb;en-us;264372&spid=1743&sid=340

 

[shrinivas]

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

 

[Mangesh Yadav]

Try:

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


Mangesh

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

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=kb;en-us;264372&spid=1743&sid=340

 

[Mangesh Yadav]

check this thread:

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


Mangesh

Try:

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


Mangesh

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

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=kb;en-us;264372&spid=1743&sid=340

------------------------------------------------------------------------

olasa's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=17760
View this thread: http://www.excelforum.com/showthread.php?threadid=380287

 

[Mangesh Yadav]

and yet another:

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


Mangesh

Try:

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


Mangesh

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

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=kb;en-us;264372&spid=1743&sid=340

------------------------------------------------------------------------

olasa's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=17760
View this thread: http://www.excelforum.com/showthread.php?threadid=380287