number separation in excel
 

i want to use number separaation in excel as 10,00,00,000.00 instead of
thousand separtion in format/cells/number. I have customized in Regional and
Language settiing for the same but it does not work in excel

number separation in excel
 

Hi Rohit

Check out the below link for an Add-In to convert to Indian format numbers
1,12,000

http://www.dq.winsila.com/tips-trick...and-words.html

If this post helps click Yes
---------------
Jacob Skaria


"rohit" wrote:

i want to use number separaation in excel as 10,00,00,000.00 instead of
thousand separtion in format/cells/number. I have customized in Regional and
Language settiing for the same but it does not work in excel

number separation in excel
 

If you have Excel 2002 or later look up bhattext in help.
Otherwise the following format might help you
[=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.
see:
http://www.google.ca/groups?q=indian...cel*&hl=en&lr=...
--
best wishes

--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"rohit" wrote in message
...
i want to use number separaation in excel as 10,00,00,000.00 instead of
thousand separtion in format/cells/number. I have customized in Regional
and
Language settiing for the same but it does not work in excel

number separation in excel
 

Bernard,
wow! it works. Thanx a lot.

"Bernard Liengme" wrote:

If you have Excel 2002 or later look up bhattext in help.
Otherwise the following format might help you
[=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.
see:
http://www.google.ca/groups?q=indian...cel*&hl=en&lr=...
--
best wishes

--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"rohit" wrote in message
...
i want to use number separaation in excel as 10,00,00,000.00 instead of
thousand separtion in format/cells/number. I have customized in Regional
and
Language settiing for the same but it does not work in excel