change number format

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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...
 
[>=10000000]##\,##\,##\,##0.00;[>=100000]##\,##\,##0.00;##,##0.00

--
HTH

Bob Phillips

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