Export from Access to Excel shifts decimal position randomly
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?
Software/Hardware used:
Software/Hardware used:
ASKED:
September 2, 2008 8:52 PM
UPDATED:
September 2, 2008 9:02 PM
RELATED QUESTIONS
- Microsoft Access Query Questions
- Problem with AS/400 data transfer to Excel
- Working with SQL: Extracting Data or Text within a Query, adding new column for extracted data
- How to concat SQL Server 2005 data with line feed
- In Access 2007 for query exports to Excel 2007 - How do you turn off Automatic backups
Answer Wiki:
Last Wiki Answer Submitted:
Be the first to answer this question.
All Answer Wiki Contributors:
Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
