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

--
HTH

Bob Phillips

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

"gaj" wrote in message
...
hi
i want to change the number format in excel .usually when i input number
like 123456789, i am getting the number as 123,456,789.00 . but i need the
number to be in Indian standard like 12,34,56,789.00. please find the
solution and reply me...