I am exporting from MS Access '03 to MS Excel '03. I retrieve several columns formatted as Fixed width with 2 decimal places in a query and then export those results to Excel. Occasionally, some of the columns, but not all values in that column, will display with the decimal point shifted one position to the left, so that 7.50 hours displays as 75.00 hours. When I copy & paste from this same query, the results are fine. Does anyone know how to correct this?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!