Results 1 to 4 of 4

Thread: Display numbers in Lakhs

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. 04-11-2012, 09:00 AM #1
    Prabhu
    Prabhu is offline
    Member
    Join Date
    Aug 2011
    Posts
    54
    Rep Power
    15
    Hi,

    Yes, i want to devid all the numbers by(100000) but is there any way to use macro for all the numbers in the paget to convert in to lakhs.

    Plz find the attached sheet whare i want to convert all the numbers value in to lakhs.

    regerds,

    Prabhu
    Attached Files Attached Files
    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. 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
  5. Display numbers in Lakhs
    By Prabhu in forum Excel Help
    Replies: 1
    Last Post: 01-29-2012, 02:18 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