Value in indian comma seperation

[DHAWAL]

I want to show value in India comma separation style, I have used this marco

Sub IndianNumberFormat()

For Each c In Selection

Select Case Abs(c.Value)

Case Is < 100000

c.Cells.NumberFormat = "##,##0.00 ;[RED]-##,##0.00"

Case Is < 10000000

c.Cells.NumberFormat = "#\,##\,##0.00 ;[RED]-#\,##\,##0.00"

Case Is < 1000000000

c.Cells.NumberFormat = "#\,##\,##\,##0.00 ;[RED]-#\,##\,##\,##0.00"

Case Is < 1000000000

c.Cells.NumberFormat = "#\,##\,##\,##0.00 ;[RED]-#\,##\,##\,##0.00"

Case Is < 100000000000#

c.Cells.NumberFormat = "#\,##\,##\,##\,##0.00 ;[RED]-#\,##\,##\,##\,##0.00"

Case Else

c.Cells.NumberFormat = "#\,##\,##\,##\,##\,##0.00 ;[RED]-#\,##\,##\,##\,##\,##0.00"

End Select

Next c

End Sub

Its run perfectly but when I change value from lakhs to thousand or crores to lakhs it shows value like this

,,25,000.00

It shows “,” before value, I have to run macro again to show this value 25,000,
Can anyone has dynamic macro that will work on any value or When I change value it will run macro again so that above error will not occur
can anyone help please ..?

 

[HongRu]

Try this macro.
You should put the below macro in your WORKSHEET (ex. sheet1) and write some marco to prevent unexpected errors.
'===========
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Call IndianNumberFormat
End Sub

 

[DHAWAL]

It doesn't work, i have to run macro again..
Please help

 

[DHAWAL]

is there is any other code through which it shows value in indian comma speration style and whenever value is updated it will automatically show value in indian comma speration style only.

 

[HongRu]

It doesn't work, i have to run macro again..
Please help

Do you put my macor in your WORKSHEET (ex. sheet1) exactly, not in some MODULE ?