Hi Aditya,
This is for postive numbers only, and there was a recent complaint
that it didn't handle numbers high enough (are we talking about
national debts here).
[>=10000000]##\,##\,##\,##0.00; [>=100000]##\,##\,##0.00;##,##0.00
(This format separates groups for India/Thailand, format valid for positive numbers up to 99,99,99,999.99 or 999,999,999.99) in
Excel XP see function BhatText as in Thai Bhat currency. =BAHTTEXT(A37) [Rupees, Rs., Paise, lakhs, crores] == an alternative may
be to use Control Panel, Regional Settings, Numbers, digit grouping.
Negative and Positive Numbers can be handled with a subroutine or event macro by Norman Harker.
http://groups.google.com/[email protected]
To see all the links look for the above text in (at bottom of table after)
http://www.mvps.org/dmcritchie/excel/formula.htm#cellformat
and a thousand apologies that you will have to look at those with the new
Google Groups Beta, besides other things it has probably changed the
formatting of Norman's macro with extra blank liknes . But I don't think
it is going to point you directly to the article within the thread -- though
haven't examined why, you might get better results with the following
link to Norman's event macro code. You might also check for options
to customize your Google Groups Beta to not use frames if they offer
you a choice in preferences. I can't be looking at that stuff now.
http://groups-beta.google.com/group...560c81b?tvc=1&scrollSave=&&d#efed95eb8560c81b
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages:
http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page:
http://www.mvps.org/dmcritchie/excel/search.htm