Indian Coma Style
 

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

Indian Coma Style
 

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

Indian Coma Style
 

Hi ****al

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

http://groups.google.com/groups?hl=e....phx.gbl#link1

Regards
Paul

"****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