Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Page 1 of 2 1 2 LastLast
Results 1 to 10 of 12

Thread: Lakh Separator. Indian Rupee Cell Format

  1. #1
    Join Date
    16th January 2005
    Location
    Dubai
    Posts
    3

    Lakh Separator. Indian Rupee Cell Format

    Dear EXCEL forum,

    I wonder anyone can help me to format cells with "lakh" separator.
    Excel allows only thousand's separator.
    The other option is to make the changes in the regional settings... which will
    affect all other application.

    Thanks in advnace for your assistance.


    B.Rgds/Krishnan Kutty
    +++

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    7th December 2005
    Location
    Hampshire, England
    Posts
    4,898

    Re: Lakh Separator

    I've read up about lakh separators - a bit weird to an Englishman! Can you give some examples of true values in the cell and how you would like the cell to look?
    Last edited by ByTheCringe2; May 23rd, 2007 at 22:55.

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    7th December 2005
    Location
    Hampshire, England
    Posts
    4,898

    Re: Lakh Separator

    Hmmm, I don't think it can be done - Excel changes whatever custom format I put in. You could use VBA to change it, or you use the TEXT function in another cell to give you what you want, and perhaps hide the original cell.

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    18th November 2004
    Location
    God's Own Country
    Posts
    4,353

    Re: Lakh Separator

    Hi,

    Try,

    VB:
    Private Sub Worksheet_Change(ByVal Target As Range) 
         '//Written by parry
        Dim c 
        If Target.Cells.Count = 1 Then 
            Select Case Target.Value 
            Case Is >= 1000000000 
                Target.Cells.NumberFormat = "##"",""00"",""00"",""00"",""000.00" 
            Case Is >= 10000000 
                Target.Cells.NumberFormat = "##"",""00"",""00"",""000.00" 
            Case Is >= 100000 
                Target.Cells.NumberFormat = "##"",""00"",""000.00" 
            Case Else 
                Target.Cells.NumberFormat = "##,###.00" 
            End Select 
        Else 
            For Each c In Target 
                Select Case c.Value 
                Case Is >= 1000000000 
                    c.NumberFormat = "##"",""00"",""00"",""00"",""000.00" 
                Case Is >= 10000000 
                    c.NumberFormat = "##"",""00"",""00"",""000.00" 
                Case Is >= 100000 
                    c.NumberFormat = "##"",""00"",""000.00" 
                Case Else 
                    c.NumberFormat = "##,###.00" 
                End Select 
            Next c 
        End If 
    End Sub 
    
    
    HTH

  5. #5
    Join Date
    8th July 2005
    Location
    india
    Posts
    71

    Re: Lakh Separator

    my god!
    krishna u r a real genius!
    marvelous!
    krishna nee begane!

    jai

    Excel Video Tutorials / Excel Dashboards Reports


  6. #6
    Join Date
    12th September 2006
    Location
    The Great State of Texas
    Posts
    4,323

    Re: Lakh Separator

    For me and any anyone else who has no idea what a lakh separator is, can someone explain?

    Excel Video Tutorials / Excel Dashboards Reports


  7. #7
    Join Date
    8th July 2005
    Location
    india
    Posts
    71

    Re: Lakh Separator

    in India lakh is numerical value for 100,000
    So everyone use it as 1,00,000 not as 100,000 (one hundred thousands)
    another value crore would mean 10,000,000
    but it is used as 1,00,00,000 (one hundred lakhs)

    hope i made u clear

    jai

    Excel Video Tutorials / Excel Dashboards Reports


  8. #8
    Join Date
    12th September 2006
    Location
    The Great State of Texas
    Posts
    4,323

    Re: Lakh Separator

    Thank you.

    Excel Video Tutorials / Excel Dashboards Reports


  9. #9
    Join Date
    7th December 2005
    Location
    Hampshire, England
    Posts
    4,898

    Re: Lakh Separator

    Told you it was weird!

    Excel Video Tutorials / Excel Dashboards Reports


  10. #10
    Join Date
    18th November 2004
    Location
    God's Own Country
    Posts
    4,353

    Re: Lakh Separator

    Quote Originally Posted by abccells
    my god!
    krishna u r a real genius!
    marvelous!
    krishna nee begane!

    jai
    The real credit goes to Graham aka parry.

Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Indian Currency Format
    By anandramnath in forum EXCEL HELP
    Replies: 9
    Last Post: July 18th, 2010, 15:04
  2. Indian Number Format
    By smaheshngp in forum EXCEL HELP
    Replies: 6
    Last Post: June 20th, 2007, 15:50
  3. Sort Cell Data Seperated By Pipe Separator (|)
    By DANDERSON in forum EXCEL HELP
    Replies: 4
    Last Post: September 30th, 2006, 04:56
  4. Separator in vba
    By major-b in forum EXCEL HELP
    Replies: 5
    Last Post: February 3rd, 2006, 21:54
  5. Dot Separator
    By Joseph in forum EXCEL HELP
    Replies: 1
    Last Post: July 22nd, 2004, 16:28

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
  •  
porno