This format was suggested in one of the links previously provided

[=10000000]##\,##\,##\,##0.00;[=100000]##\,##\,##0.00;##,##0.00


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"shah****al" wrote in message
...
[9999999]"Rs."##\,##\,##\,##0;
[99999]"Rs."##\,##\,##0;"Rs."##,##0
this i get from google Search but it works only +ve
if i want in -ve also with (bracket)it's not working and
i want above 99 crores.

****al

Plz help me.