ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   format changes on export from Quickbooks (https://www.excelbanter.com/excel-discussion-misc-queries/256653-format-changes-export-quickbooks.html)

Anne

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?


All times are GMT +1. The time now is 09:57 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com