I have been searching for a solution to this problem on the internet - but for reasons, I do not understand no solutions seems to work
In each of my cells in a range
cell A2 formatted as text and value is 11-12-2014 which equals December 11th 2014
Cell A3 formatted as text and value is 04-12-2014 which equals December 4th 2014
how can these be converted to the Danish shortdate format 11-12-2014
I need this done in VBA
I have tried the following solutions
Dim c As Range
For Each c In ActiveSheet.UsedRange.columns("A").Cells
c.Value = CDate(c.Value)
For Each c In Selection.Cells
c.Value = Replace(c.Value, ".", "-")
c.NumberFormat = "dd-mm-yyyy"
as well as a couple of recorded macros.
a couple of solutions Work fine, when I record the macro, but when I run the solution on more than one cell my dates are converted to
12th november 2014 (12-11-2014)
12th april 2014 (12-04-2014)
How can I Work around that VBA wants to speek English?