How to Change the Date Format in VBA Code?

[punnipah]

Hi,

i wan to Convert Format dd/mm/yyyy to yyyy/mm/dd




My Code Can't Working

Sub Date_Format_Example2()

Range("A1").NumberFormat = "yyyy/mm/dd"

End Sub

Data

Book1
	A
1	12.02.2023
Sheet1

 

[MARK858]

Try...

Sub Date_Format_Example2()

    With Range("A1")
        .Replace What:=".", Replacement:="/", LookAt:=xlPart
        .NumberFormat = "yyyy/mm/dd"
    End With

End Sub

 

[Phuoc]

...

 

[punnipah]

Try...

Sub Date_Format_Example2()

    With Range("A1")
        .Replace What:=".", Replacement:="/", LookAt:=xlPart
        .NumberFormat = "yyyy/mm/dd"
    End With

End Sub

Thank you Very much

 

[MARK858]

You're welcome