Hi, I have cells of data with a long string of numbers such as: 20090507225836
Is there any easy way to convert them to date/time format, such as below?
5/7/2009 22:58:36
Thanks!
Hi, I have cells of data with a long string of numbers such as: 20090507225836
Is there any easy way to convert them to date/time format, such as below?
5/7/2009 22:58:36
Thanks!
Last edited by ajchandler; 05-08-2009 at 01:48 PM.
One way:
=DATE(LEFT(A1,4),MID(A1,5,2),MID(A1,7,2))+TIME(MID(A1,9,2),MID(A1,11,2),RIGHT(A1,2))
formatted as desired
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Or =TEXT(A1, "0000-00-00 00\:00\:00") + 0 and format as desired.
Entia non sunt multiplicanda sine necessitate
Both of those ways work. YOU GUYS ROCK!!
FYI.. not that I need to, but excel doesn't let me subtract the cell using one method from the cell using the other method. In other words, I'll need to choose one formula or the other.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks