How to convert Short date to Long date?
As shown in image, I convert Expiry date to long date from format, but two of them did not change however I use some function but It did not work also for the one didn’t change.
What is the problem with these dates?
31/01/2017
16/06/2018
Note: Function used to convert date is
=TEXT (B2,”DDD, MMM, YYYY”)
Did you enter those two dates in Column B as Date?Originally Posted by hanialbarni
Last edited by sanram; 08-13-2016 at 06:17 AM. Reason: Edited as FDibbins say.
sanram Don't quote whole posts -- it's just clutter. If you are responding to a post out of sequence, limit quoted content to a few relevant lines that makes clear to whom and what you are responding
For normal conversational replies, try using the QUICK REPLY box below.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
hanialbarni welcome to the forum
It is hard to tell from a pic what your underlying data actually looks like. Can you upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.
Hi,
Try this =TEXT(B2,"ddd,DD,MMM,YYYY")
Thank You.....
Re: How to convert Short date to Long date?
AMsanram,
Yes all of them format as Date.
AMFDibbins,
Kindly find attached file.
arshad.99.ali
It didn't work
In your uploaded sheet B3 and B6 aren't in the correct date format with respect to your date & time settings. Enter those date in correct format, then it will work. Say, you want 31/01/2017 then enter 1/31/2017. i.e. Month/Day/Year.
Or if you want to work with your current data, then enter the below formula in C2 and copy down.
Please Login or Register to view this content.
Hi Hanialbarni,
After checking your template i would suggest you to Convert "Text to column" for Date values (Column B) and apply formula to get output
Convert Text to column - Delimited - Tab - General or Date - Finish
It is working for me after doing above step. Hope this will works for you......
However sanram post also working fine...
Thanks you......
sanram,
Yes it worked, Thank you.
arshad.99.ali,
I did not understand what you mean
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks