I found this excel addin, and I need to change the date format and locale, but when I use numberformat in the cell, the date format doesn't change:
Excel date addin
This si the code I am using:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$A$1" Then...