View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Anne Anne is offline
external usenet poster
 
Posts: 74
Default format changes on export from Quickbooks

I just loaded office 2007. In office 2003, I exported this particular file,
where one colum displays hours worked and the hours came over as hours, for
example 8.00.
Now in office 2007, it makes the 8 hours into 8:00:00 AM, which if formated
numberic becomes .333 hrs.

These numbers get imported into an existing formatted spreadsheet, but it
still comes over as time. What do I do?