Here is a previous posting by David McRitchie on this topic which might get
you started:
Message 2 in thread
From: David McRitchie )
Subject: 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/assistan...l/Bahttext.htm
otherwise I have an example on my
Show FORMULA of another cell in Excel
http://www.mvps.org/dmcritchie/excel...tFormatExample
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/assistan...l/Bahttext.htm
http://groups.google.com/groups?selm...%40tkmsftngp02
http://groups.google.com/groups?thre...l fitness.com
FWIW, most questions have been asked before,
You can search the archived newsgroups in Google Groups
http://groups.google.com/advanced_gr...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.
---
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
-- Regards,Tom Ogilvy"****al" wrote in message
...
I want to use Indian Comma style upto 100 crores. with -ve
value have to come in ()Bracket.
like.
100
1,000
10,000
1,00,000
10,00,000
1,00,00,000
10,00,00,000
1,00,00,00,000
with -ve
(100)
(1,000)
(10,000)
(1,00,000)
(10,00,000)
(1,00,00,000)
(10,00,00,000)
(1,00,00,00,000)
is any help