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
VBAVB ScriptMicrosoft ExcelMicrosoft Office
Last Comment
Bill Prew
They all look fine to me. What formula is trying to use them?
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
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!