LinkBack URL
About LinkBacks
Hello,
In the attached sheet, I want a macro which will convert the date from dd-mon-yyyy to yyyy/mm/dd format for the two columns.
Can anyone help me.
Advance thanks
Hello,
In the attached sheet, I want a macro which will convert the date from dd-mon-yyyy to yyyy/mm/dd format for the two columns.
Can anyone help me.
Advance thanks
Why do you need a macro? Is there an issue with simply formatting those columns with the desired date format?
Thanks,
Solus
Please remember the following:
1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.Highlight the code in your post and press the # button in the toolbar.2. Show appreciation to those who have helped you by clickingbelow their posts.
3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
"Slow is smooth, smooth is fast."
Thanks for your quick response
In my project, i am using more than 20 macro to generate the output which I got from Oracle.
If a macro is developed to format the date in requested format, then it will be easier for the end user without using excel formula.
Are you asking that the dates seperated by commas be formatted also? Are they supposed to be separated into their own cells?
Please Login or Register to view this content.
Thanks solus for your help.
I forgot to add one more point. Please check the newly attached sheet once again where I have added date with time also.
How the macro will work and display only date (excluding time)
Please Login or Register to view this content.
Try this
Please Login or Register to view this content.
Thanks to both of you for looking into the matter.
Macro is working perfectly, as given by Solus.
Dear Jindon, the date is not being converted
Should work.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks