Link to home
Create AccountLog in
Avatar of Enrique A. Santos KM4ZQC
Enrique A. Santos KM4ZQCFlag for United States of America

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
Avatar of Wayne Taylor (webtubbs)
Wayne Taylor (webtubbs)
Flag of Australia image

They all look fine to me. What formula is trying to use them?
ASKER CERTIFIED SOLUTION
Avatar of Shums Faruk
Shums Faruk
Flag of India image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of Enrique A. Santos KM4ZQC

ASKER

That's it!!!
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.
Avatar of Bill Prew
Bill Prew

Wow!