number separation in excel

  • Thread starter Thread starter rohit
  • Start date Start date
R

rohit

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
 
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+currency+group:*excel*&hl=en&lr=...
 
Bernard,
wow! it works. Thanx a lot.

Bernard Liengme said:
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+currency+group:*excel*&hl=en&lr=...
--
best wishes

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


rohit said:
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
Click to expand...
Click to expand...
 
Back
Top