Excel Number format in Indian style (Lacs, Crores)

Discussion in 'Microsoft Excel Discussion' started by amitchand, Aug 30, 2004.

  1. amitchand

    amitchand Guest

    HI,

    Someone please help me in changing numbers in excel to Indian forma
    ..

    say for ex.... 123456789 has to be displayed as 12,34,56,789 whic
    basically is Rs. 12 crores 34 lacs 56 thousand and 789 rupees as pe
    Indian currency system..

    thanks

    amit chan

    --
    Message posted from http://www.ExcelForum.com
     
    amitchand, Aug 30, 2004
    #1
    1. Advertisements

  2. From a Google search here is a reply by David Richie to the same question in
    January

    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=india...=&rnum=1

    --
    Bernard Liengme
    www.stfx.ca/people/bliengme
    remove CAPS in e-mail address


    "amitchand >" <<> wrote in message
    news:...
    > HI,
    >
    > Someone please help me in changing numbers in excel to Indian format
    > .
    >
    > say for ex.... 123456789 has to be displayed as 12,34,56,789 which
    > basically is Rs. 12 crores 34 lacs 56 thousand and 789 rupees as per
    > Indian currency system..
    >
    > thanks
    >
    > amit chand
    >
    >
    > ---
    > Message posted from http://www.ExcelForum.com/
    >
     
    Bernard Liengme, Aug 30, 2004
    #2
    1. Advertisements

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

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Mahesh Kumar K Hegde

    Indian rupees

    Mahesh Kumar K Hegde, Nov 23, 2004, in forum: Microsoft Excel Discussion
    Replies:
    3
    Views:
    619
    Mahesh Kumar K Hegde
    Nov 25, 2004
  2. Mahesh Kumar K Hegde

    Convert Number To Indian Rupees

    Mahesh Kumar K Hegde, Nov 29, 2004, in forum: Microsoft Excel Discussion
    Replies:
    4
    Views:
    9,464
    David McRitchie
    Nov 29, 2004
  3. Mahesh Kumar K Hegde

    Indian style Number Format

    Mahesh Kumar K Hegde, Dec 11, 2004, in forum: Microsoft Excel Discussion
    Replies:
    1
    Views:
    389
    Niek Otten
    Dec 11, 2004
  4. Mahesh

    How Can set numbers in Indian Style

    Mahesh, Jul 8, 2005, in forum: Microsoft Excel Discussion
    Replies:
    6
    Views:
    168
    Bernard Liengme
    Jul 8, 2005
  5. Bernard Liengme

    Date format in Indian style

    Bernard Liengme, Dec 6, 2007, in forum: Microsoft Excel Discussion
    Replies:
    1
    Views:
    449
    Krishna Kumar L
    Dec 6, 2007
Loading...

Share This Page