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.
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?
Avatar of Shums Faruk
Shums Faruk
Flag of India image

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


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