+ Reply to Thread
Results 1 to 4 of 4

Conversion of actual fig. in Lakhs / Crores

  1. #1
    Ajit Munj
    Guest

    Conversion of actual fig. in Lakhs / Crores

    I use Excel 2000 (9.0.2720)

    In range A1:D10, I have entered the figures in actuals (e.g. 34532642.45,
    78945624.89 etc.). How can I convert those figures in Lakhs / Thousands /
    Crores? Before converting, Can Excel 2000 prompt me for conversion in Lacs /
    Thousands / Crores?

  2. #2
    Registered User
    Join Date
    02-01-2005
    Posts
    10
    Any number can be converted into any units.

    Say in u r case we have to convert the figuer in Lacs

    e.g 153469782.

    Now what u do punch 100,000 in one cell ,copy this number and select the range where u want to convert into lacs say above figuer select that cell do paste special and click the option divide ans see the magic

  3. #3
    Registered User
    Join Date
    01-27-2010
    Location
    Delhi
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Conversion of actual fig. in Lakhs / Crores

    Harish kumar you are writ. i was serching this formula from three years. I got it. thanks.

  4. #4
    Registered User
    Join Date
    04-12-2015
    Location
    india
    MS-Off Ver
    2007
    Posts
    1

    Re: Conversion of actual fig. in Lakhs / Crores

    please tell me how to convert crores into lakhs in excel or y hand ?

    eg:6,46,783.5 8,09,963.0 9,35,536.9 4,73,174.3 6,03,763.0 7,10,345.6 e?ct are in crores how can i convert into lakhs?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1