Related:
- Convert date format
- How to change date format in excel - Guide
- Kingston format utility - Download - Storage
- Convert m3u to mp3 - Guide
- How to convert free fire id facebook to google - Guide
- Convert dts to ac3 mkvtoolnix - Guide
1 response
in vba:
Dim strMonth As String
Dim strDay As String
Dim strYear As String
Dim strDATEVALUE As String
Dim strNewDate As String
strDATEVALUE = "72310"
strYear = Right(strDATEVALUE, 2)
strDay = Left(Right(strDATEVALUE, 4), 2)
strMonth = Replace(strDATEVALUE, strDay & strYear, "")
strNewDate = strYear & String(2 - Len(strMonth), "0") & strMonth & strDay
MsgBox strNewDate
Dim strMonth As String
Dim strDay As String
Dim strYear As String
Dim strDATEVALUE As String
Dim strNewDate As String
strDATEVALUE = "72310"
strYear = Right(strDATEVALUE, 2)
strDay = Left(Right(strDATEVALUE, 4), 2)
strMonth = Replace(strDATEVALUE, strDay & strYear, "")
strNewDate = strYear & String(2 - Len(strMonth), "0") & strMonth & strDay
MsgBox strNewDate
