Dear Sir,

Presently I am using [>=10000000]##\,##\,##\,##0 ;[>=100000] ##\,##\,##0 ;##,##0 customized format to denote numbers in Indian denomination, but while entering "zero" in a particular cell it displaying as 0 and negative numbers with - sign before the number. but I just want to denote 0 as - and negative numbers should be in () and to display same as Indian denominations as 1,00,00,000 and (1,00,00,000)so please customize the above format applicable to my requirements

Thanks in advance.