change number format

G

gaj

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...
 
B

Bob Phillips

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

--
HTH

Bob Phillips

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