Hi.
I've recently recorded this macro to change dates like "JAN 13" to a "JAN 2013" format. I recorded this macro using find and replace and I achieved the desired result.
When I run the recorded macro, the date "JAN 13" is changed to "JAN 202013"
I can't figure out why this is or how to fix it. I tried searching by columns but that didn't work. Can anyone tell me what went wrong?
Thanks.
Please Login or Register to view this content.
Last edited by Trevasaurus; 01-29-2013 at 05:58 PM. Reason: File Upload
upload file
Try this. Change the "mmm yyyy" date format to suit.
Please Login or Register to view this content.
Hey AlphaFrog
I tried adding the number format to the bottom of my code but it's still creating extended years, i.e. 202013.
I'm watching the code go through and it does what I want first, then it goes through and changes all the 2013's & 2014's to 202013 & 202014.
My actual macro goes out to the year 2027. I don't know if that has anything to do with my problem.
I've noticed that my problem stops if I end my macro before the year 2020.
Try this...
Please Login or Register to view this content.
try this code
Please Login or Register to view this content.
@ Alphafrog.
That works perfectly. And it's a lot faster than my initial approach. Thanks a lot.
Press star @ Alphafrog
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks