excel01noob
Board Regular
- Joined
- Aug 5, 2019
- Messages
- 93
- Office Version
- 365
- 2016
I have a monthly report which gives me the dates with this format
2021-03-01T00:00:00.000000
I have another column which is filling with with the 10 first left characters as yyyy-mm-dd
I want now to have this date showing in the European format as 01 March 2021
how do I do that?
This one does not work well
Sub dates()
Dim LastRow As Long
LastRow = Cells(Rows.Count, "Q").End(xlUp).Row
For r = 2 To LastRow
Range("Q" & r).NumberFormat = "mmmm dd yyyy"
Next r
End Sub
2021-03-01T00:00:00.000000
I have another column which is filling with with the 10 first left characters as yyyy-mm-dd
I want now to have this date showing in the European format as 01 March 2021
how do I do that?
This one does not work well
Sub dates()
Dim LastRow As Long
LastRow = Cells(Rows.Count, "Q").End(xlUp).Row
For r = 2 To LastRow
Range("Q" & r).NumberFormat = "mmmm dd yyyy"
Next r
End Sub