Results 1 to 2 of 2

Thread: Display numbers in Lakhs

  1. 01-27-2012, 02:45 PM #1
    Prabhu
    Prabhu is offline
    Member
    Join Date
    Aug 2011
    Posts
    54
    Rep Power
    13

    Display numbers in Lakhs

    Hi,

    In Excel I needs to convert numbers in to indian format and the value should divided by lakhs and display in Lakhs.

    Example Rs.924104600.90 should reflect as Rs.9,241(in lakhs, Indian format)

    Plz help.

    Regards,

    Prabhu



    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA

    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
    https://www.youtube.com/watch?v=QjEWAJ3d-jw&lc=UgxJLVpwY8fIla7G-pN4AaABAg.9BLeCWVhxdG9wgNsaS3Lp1
    https://www.youtube.com/watch?v=QjEWAJ3d-jw&lc=UgxJLVpwY8fIla7G-pN4AaABAg.9BLeCWVhxdG9wgR1EPUkhw
    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
    Last edited by DocAElstein; 11-20-2023 at 03:54 PM.
    Reply With Quote Reply With Quote
  2. 01-29-2012, 02:18 PM #2
    Admin
    Admin is offline
    Administrator Admin's Avatar
    Join Date
    Mar 2011
    Posts
    1,122
    Rep Power
    10
    Hi Prabhu,

    Try

    ="Rs."&TEXT(--MID(A2,4,20)/100000,"#,##0.00")
    Cheers !

    Excel Range to BBCode Table
    Use Social Networking Tools If You Like the Answers !

    Message to Cross Posters

    @ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Change Display Range Based On Change of Dropdown Values
    By rich_cirillo in forum Excel Help
    Replies: 2
    Last Post: 03-29-2013, 04:58 AM
  2. Display sheet names in a message box
    By pells in forum Excel Help
    Replies: 4
    Last Post: 02-13-2013, 07:33 PM
  3. Formula to Display Month and Dates Using Spin Button
    By ayazgreat in forum Excel Help
    Replies: 6
    Last Post: 11-21-2012, 10:19 PM
  4. Display numbers in Lakhs
    By Prabhu in forum Excel Help
    Replies: 3
    Last Post: 04-11-2012, 10:19 AM
  5. Format Cell To Convert Display Number As Billion / Million / Thousand
    By excel_learner in forum Excel Help
    Replies: 4
    Last Post: 03-10-2012, 07:15 PM

Bookmarks

Posting Permissions

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

Forum Rules