Не могу найти ошибку, переводит в дату если активировать ячейку:(
Range("J:J").Select
With ActiveWindow.RangeSelection
.Replace ",", "."
arr = .Value
.NumberFormat = "dd/mm"
.Value = arr
End With
End Sub
Range("J:J").Select
With ActiveWindow.RangeSelection
.Replace ",", "."
arr = .Value
.NumberFormat = "dd/mm"
.Value = arr
End With
End Sub