Lease convert these dates to as MM-DD-YYYY i have tried but there is some issue.
Date Conversion to MM-DD-YYYY
- ArhamRajput
- Thread is marked as Resolved.
-
-
Not sure which dates need to be converted. Suggest you provide more detailed information about your worksheet and what you want to happen. Your explanation and worksheet are not clear. We are not mind readers here, but we are excellent excel helpers.
-
Code
Sub Maybe() Dim c As Range For Each c In Range("A2:A" & Cells(Rows.Count, 1).End(xlUp).Row).SpecialCells(2) c.Offset(, 2).Value = "'" & Format(c, "MM-DD-YYYY") Next c End Sub -
Not sure what you have tried?
In the format dropdown, select "more number formats" then custom - select any of the date formats and then modify to the mm/dd/yyyy format... or, change your default language if you are supposed to use this format in your region.
-
-
Use:
=DATEVALUE(A20)
then follow the format instructions in the previous post.
Regards
Justin
-
I have tried, it worked fine.
-
If you are using Excel 2016, then converting the format in Power Query is a quick and simple step.
-
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!