FORMAT NUMBERS OR CURRENCY

  • Thread starter Thread starter Guest
  • Start date Start date
The only way to format a number in that way is to format it as text
(Format>Cells>Number), which means that the number is displayed exactly as
entered, but it would mean that you would have to enter it as
10,20,34,000.00 and do the same every time you want to enter a number into
the same cell.
 
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
 
Back
Top