please anyone let me know how to convert number i.e. 01062010
to date format i.e. 01-Jun-2010
please anyone let me know how to convert number i.e. 01062010
to date format i.e. 01-Jun-2010
hi raheelrr, welcome to the forum. try:
=DATE(RIGHT(A1,4),MID(A1,3,2),LEFT(A1,2))
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Thanks for ur reply.
Or
Formula:Please Login or Register to view this content.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
My Post #4 suggestion fails when the Regional Date And Time Setting is set to MM-DD-YYYY, so please ignore it and use the formula suggested by benishiryo in Post #2.
PS: Thanks to benishiryo for describing the right usage
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks