Pl help me format a number to read as per this example - 10,20,34,000.00

The only way to format a number in that way is to format it as text
(FormatCellsNumber), 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...cel*&hl=en&lr=...




best wishes

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


"Venky" wrote in message
...
Pl help me format a number to read as per this example - 10,20,34,000.00