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" wrote in message
...
Try:

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


Mangesh



"shrinivas" wrote in message
...
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