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?
|