Keep original date format after execution
Hi,
My codes are below and seem working well except for a small problem after execution. The dates formats are being converted to “dd.mm.yyyy” even though I add a piece of code to retrieve the previous date format of “dd.mm.yy”.
My question is how to keep the original date format of “dd.mm.yy” after execution. Thanks in advance for your prompts.
Please Login or Register to view this content.
Get rid of the Format in each case.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Re: Keep original date format after execution
Dear TMS,
I am not sure whether I understood right but add this codeafter "DateAdd" lines but did not help. My code is converting the dates to next year only without touching days & months. Unfortunately the vba is also changing my original date format from "dd.mm.yy" to "dd.mm.yyyy" but need to keep it same as "dd.mm.yy". You can see my sample file in attachment. ThanksPlease Login or Register to view this content.
No. VBA Format is like the Excel Text function ... so you get text out of it. After that, it doesn't matter what format you clear or apply, it won't make any difference. So lose the Format.
needs to becomePlease Login or Register to view this content.Please Login or Register to view this content.
ThisPlease Login or Register to view this content.
That's what I need. Thank you very much indeed
You're welcome. Thanks for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks