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:
    877
    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:
    12,642
    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:
    638
    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:
    366
    Bernard Liengme
    Jul 8, 2005
  5. How to format number with mixed number and text?

    , Oct 22, 2005, in forum: Microsoft Excel Discussion
    Replies:
    1
    Views:
    289
    RagDyeR
    Oct 22, 2005
  6. Currency Style Button applies Accounting Style

    , Oct 25, 2006, in forum: Microsoft Excel Discussion
    Replies:
    1
    Views:
    316
    RagDyer
    Oct 25, 2006
  7. Bernard Liengme

    Date format in Indian style

    Bernard Liengme, Dec 6, 2007, in forum: Microsoft Excel Discussion
    Replies:
    1
    Views:
    649
    Krishna Kumar L
    Dec 6, 2007
  8. yair

    number format - minus sign away from number

    yair, Jan 29, 2009, in forum: Microsoft Excel Discussion
    Replies:
    2
    Views:
    474
    Bob Phillips
    Jan 29, 2009
Loading...