Sign in
 
Home20102007Office 365Office for MacLibraryForums
Office > Microsoft Office Forums > Excel IT Pro Discussions > Excel 2010 - time field imported as 0

Unanswered Excel 2010 - time field imported as 0

    •  
      Thursday, February 23, 2012 5:22 AM
       
       
      Sign In to Vote
      0
      Sign In to Vote

      I have many Excel files that use MS query to bring in data from an AS400. Many of these were created in Excel 2003, work just fine in  Excel 2007, but are a problem in Excel 2010. Imported time fields (hh:mm:ss) look fine in the MS query, but come over to the Excel sheet as a 0. The column gets formatted automatically as time, but the value in every cell is 0. It is not a problem with the first record brought over, and not a formatting problem.  

      I've seen very similar posts in this forum with time fields imported from other sources, other database types, but I haven't seen an explanation and solution posted yet.

      I would greatly appreciate any suggestions.

      Thanks

       

    All Replies

    • Thursday, March 01, 2012 2:00 AM
      Moderator
       
       
      Sign In to Vote
      0
      Sign In to Vote

      Hello mushroomhunter,
       
      Thank you for your post.
       
      This is a quick note to let you know that we are performing research on this issue.


      Sincerely
      Rex Zhang

      Rex Zhang

      TechNet Community Support

       
    • Tuesday, April 03, 2012 10:07 PM
      Answerer
       
       
      Sign In to Vote
      0
      Sign In to Vote

      Hi mushroomhunter

      Have you tried taking Query out of the equation?  I know if it works it's not a solution, but it would help us pinpoint the next step to take.

      Please remember to mark this as "answer" if it resolves/answers your issue.