Related:
- Convert date format
- Excel date format dd.mm.yyyy - Guide
- Convert m3u to mp3 - Guide
- Convert picture to shape powerpoint - Guide
- Format factory - Download - Other
- How to convert number to words in word - 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
