Here is a previous posting by David McRitchie on this topic which might get
you started:
Message 2 in thread
From: David McRitchie (
[email protected])
Subject: Re: customizing India number format
View this article only
Newsgroups: microsoft.public.excel.misc
Date: 2003-08-24 09:35:48 PST
Hi Anuj,
If you have Excel 2002 (and everyone using your sheet also has) then
you can look in HELP. The article is
http://office.microsoft.com/assistance/offhelp/offxp/excel/xlmain10/html/Bahttext.htm
otherwise I have an example on my
Show FORMULA of another cell in Excel
http://www.mvps.org/dmcritchie/excel/formula.htm#GetFormatExample
I will copy it out to here for you.
display as: 1,00,00,000
format is:
[>=10000000]##\,##\,##\,##0.00;[>=100000]##\,##\,##0.00;##,##0.00
comment:
(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.
links withing the above text:
http://office.microsoft.com/assistance/offhelp/offxp/excel/xlmain10/html/Bahttext.htm
http://groups.google.com/groups?selm=OwOZ4VaBBHA.1812@tkmsftngp02
http://groups.google.com/[email protected]
FWIW, most questions have been asked before,
You can search the archived newsgroups in Google Groups
http://groups.google.com/advanced_group_search?q=group:*Excel*&num=100
then for search all words:, you can put in the name of the currency and you
should at least come up with something.