Results 1 to 2 of 2

Thread: Displaying the No. 37079800000 as ₹ 370.798 Cr (Crores of Rupees)

  1. #1

    Displaying the No. 37079800000 as ₹ 370.798 Cr (Crores of Rupees)



    Register for a FREE account, and/
    or Log in to avoid these ads!

    The number in the thread is a financial figure. I need to display it in Crores (Cr) of Rupees (₹)

    I have managed to put commas on the currency and format. But since the , divides the number by thousands I end up getting a display of ₹ 37.08 Cr or ₹ 37079.80 Cr.

    In short, I need one symbol that divides by 100 instead of 1,000 like the , symbol does.

    The custom formula I used for the various numbers are

    ₹ 37.08 Cr _ [$₹-en-IN] * 000.00,,," Cr"_ ;
    ₹ 37079.80 Cr _ [$₹-en-IN] * 00.00,," Cr"_ ;

    Would really be grateful for guidance on this

  2. #2
    Acolyte Sahil1390's Avatar
    Join Date
    Nov 2016
    Location
    India
    Posts
    62
    Articles
    0
    Excel Version
    2007
    Use this custom

    [>=10000000]##\,##\,##\,##0;[>=100000] ##\,##\,##0;##,##0

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •