Mushy peas
New Member
- Joined
- Jun 14, 2023
- Messages
- 33
- Office Version
- 2019
- 2016
- Platform
- Windows
I have a range (let's call it the A column) that has dates in this format: dd.mm.yyyy so I want to change the format to short dates d/m/yyyy
Instead when I use range.replace, it takes the values as if it is in the mm/dd/yyyy format. How do I replace it.
Instead when I use range.replace, it takes the values as if it is in the mm/dd/yyyy format. How do I replace it.
VBA Code:
Sub format_dates()
Sheet1.Columns(1).Replace ".", "/"
End Sub
Last edited by a moderator: