Please can you assist me with converting the following text to date time format (yyyy/mm/dd hh:mm)
20110701 09:46
Thanks
Neil
Please can you assist me with converting the following text to date time format (yyyy/mm/dd hh:mm)
20110701 09:46
Thanks
Neil
if the above text in cell # A1, in B1 try
=--(MID(A1,5,2)&"/"&MID(A1,7,2)&"/"&LEFT(A1,4)&" "&RIGHT(A1,5))
and apply the date & time format mm/dd/yyyy h:mm
Azam
If you want to say Thank you to a member, click the reputation icon (Star) in the left bottom of the post.
For prompt answer, be descriptive, concise, short, direct, and to-the-point.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks