We help IT Professionals succeed at work.

Need VBA code to change date format of Column A

787 Views
Last Modified: 2017-03-06
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
Comment
Watch Question

CERTIFIED EXPERT

Commented:
They all look fine to me. What formula is trying to use them?
Managing Director/Excel VBA Developer
CERTIFIED EXPERT
Distinguished Expert 2018
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION
Enrique A. Santos KM4ZQCCustomer Service Representative

Author

Commented:
That's it!!!
CERTIFIED EXPERT

Commented:
Hmmm. The same can be done with a single line of code...

Range("A4:A" & Activesheet.UsedRange.Rows.Count).NumberFormat = "mm/dd/yy"

Open in new window


The reason being is that they are already real dates. Just format them how you want.
Bill PrewTest your restores, not your backups...
CERTIFIED EXPERT
Expert of the Year 2019
Top Expert 2016

Commented:
Wow!