Announcement

Collapse
No announcement yet.

Lakh Separator. Indian Rupee Cell Format

Collapse
This topic is closed.
X
X
  • Filter
  • Time
  • Show
Clear All
new posts

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

  • #2
    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, 22:55.
    .

    Comment


    • #3
      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.
      .

      Comment


      • #4
        Re: Lakh Separator

        Hi,

        Try,

        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
        Kris

        ExcelFox

        Comment


        • #5
          Re: Lakh Separator

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

          jai

          Comment


          • #6
            Re: Lakh Separator

            For me and any anyone else who has no idea what a lakh separator is, can someone explain?
            Entia non sunt multiplicanda sine necessitate.

            Comment


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

              Comment


              • #8
                Re: Lakh Separator

                Thank you.
                Entia non sunt multiplicanda sine necessitate.

                Comment


                • #9
                  Re: Lakh Separator

                  Told you it was weird!
                  .

                  Comment


                  • #10
                    Re: Lakh Separator

                    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.
                    Kris

                    ExcelFox

                    Comment


                    • #11
                      Re: Lakh Separator

                      Can some explain me how to active this worksheet change?

                      Biz

                      Comment


                      • #12


                        Re: Lakh Separator

                        Biz, you have been here long enough to know this text that you acknowledged when posting
                        If you did start this Thread and you have another question do NOT post it here. Please start a New Thread in the most appropriate Question Forum. This way the forums remain Search Friendly

                        Comment

                        Working...
                        X