Enrique A. Santos KM4ZQC
asked on
Need VBA code to change date format of Column A
Column A has several dates, but it's not readable for formula, please provide VBA code to convert all the date at once. Thank you.
AUTO-REGION-10-UTILIZATION-REPORT-2.xlsm
AUTO-REGION-10-UTILIZATION-REPORT-2.xlsm
They all look fine to me. What formula is trying to use them?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
That's it!!!
Hmmm. The same can be done with a single line of code...
The reason being is that they are already real dates. Just format them how you want.
Range("A4:A" & Activesheet.UsedRange.Rows.Count).NumberFormat = "mm/dd/yy"
The reason being is that they are already real dates. Just format them how you want.
Wow!