+ Reply to Thread
Results 1 to 3 of 3

Imported data not formatting as time

  1. #1
    Registered User
    Join Date
    05-15-2012
    Location
    United Kingdom
    MS-Off Ver
    Excel 2007
    Posts
    19

    Imported data not formatting as time

    Can anybody help?

    I have data that has come from an outside program that is set as general on the format option this means that when I try and add or minus 2 times together it is not giving me the correct answer. I thought it would of been as simple as changing the format but it doesn't work...

    Does anybody have a solution?

    Thanks

  2. #2
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,366

    Re: Imported data not formatting as time

    try this.
    select the cells go t o "text to column ) ----- date"
    I think people forget the word "THANK YOU!!!!" Do you still know it???

    There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "

    Regards,
    Vladimir

  3. #3
    Registered User
    Join Date
    05-15-2012
    Location
    United Kingdom
    MS-Off Ver
    Excel 2007
    Posts
    19

    Re: Imported data not formatting as time

    Sorry I don't understand, what do I do?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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