Results 1 to 6 of 6

convert long number in cell to date and time

Threaded View

ajchandler convert long number in cell... 05-08-2009, 10:02 AM
NBVC Re: convert long number in... 05-08-2009, 10:13 AM
shg Re: convert long number in... 05-08-2009, 11:08 AM
NBVC Re: convert long number in... 05-08-2009, 11:15 AM
ajchandler Re: convert long number in... 05-08-2009, 12:55 PM
NBVC Re: convert long number in... 05-08-2009, 01:04 PM
  1. #1
    Registered User
    Join Date
    05-06-2009
    Location
    Boston, MA
    MS-Off Ver
    Excel 2000
    Posts
    2

    convert long number in cell to date and time

    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.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1