+ Reply to Thread
Results 1 to 8 of 8

Convert Text to Date

  1. #1
    Registered User
    Join Date
    11-25-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    45

    Convert Text to Date

    Hi there,
    I have two issues with date/time formatting that I'd appreciate some feedback on. I have a formula that rearranges data from a DDE link into the proper date/time format however, Excel is not recognizing it as a date/time. I need it to recognize both the date and the time, but DateValue or TimeValue only formats as one or the other. The DDE link returns the date/time in the following format:

    2013.04.08 08:01

    and the formula returns it as:

    04/08/2013 08:01:00

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Also, the time that I am receiving from the link is 7 hours ahead of my local time. I need the time to be subtracted by 7 hours. This seems to be tricky...

    Any feed back is greatly appreciated.

    Thanks!

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,637

    Re: Convert Text to Date

    Slight Change in your formula

    Formula: copy to clipboard
    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

  3. #3
    Registered User
    Join Date
    11-25-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    45

    Re: Convert Text to Date

    @Sixthsense That was quick, Thanks! Now I just need to figure out how to get it into the proper Date/Time format.

  4. #4
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,637

    Re: Convert Text to Date

    Now I just need to figure out how to get it into the proper Date/Time format
    I am not clear about your above statement can you please explain it?

  5. #5
    Registered User
    Join Date
    11-25-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    45

    Re: Convert Text to Date

    The formula provides the format:

    04/08/2013 08:01:00

    however, Excel does not recognize it as a Date/Time. It only recognizes it as text.

  6. #6
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,637

    Re: Convert Text to Date

    remove the text function and use it like this...
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Format the cell as
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  7. #7
    Registered User
    Join Date
    11-25-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    45

    Re: Convert Text to Date

    That did the trick. Thanks for the help!

  8. #8
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,637

    Re: Convert Text to Date

    Glad it helps you and thanks for the feedback

+ Reply to Thread

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