FORMAT NUMBERS OR CURRENCY

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
(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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

number format 3
Convert number to word 5
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Currency autofit 5
Same column Percent and Currency 7
News Bank of England considers digital currency 4
Stop XL from changing format? 1
conditional number format dependent on other cell 2

Back
Top