Indian Coma Style

[Shital]

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

 

[Tom Ogilvy]

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.

 

[Paulw2k]

Hi Shital

This has been discussed before (Feb 2003). Below will lead you to the
discussion

http://groups.google.com/[email protected]#link1

Regards
Paul