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

will format say 1234567890 as 123,45,67,890.00

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"eereokatohar" wrote in message
...
Sir ,
i want to numbers written in cells be displayed as grouped in indian
format
i.e. a number of 123456.00 can how be automatically group as 1,23,456.00
instead of 123,456.00