Hello,
I have number which extract from system and that number is not date format, however I want to convert this number to format date. Anyway one know the formular for this or not.
Hello,
I have number which extract from system and that number is not date format, however I want to convert this number to format date. Anyway one know the formular for this or not.
In C3 Cell
=TEXT(TEXT(A3,"####\-##\-##"),"DD-MMM-YY")
Drag it down....
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
Maybe something like this
Formula:Please Login or Register to view this content.
Thanks,
Mike
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
Thank you so much, it work well now.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks