if I set the format in Excel to fixed with 2 decimals.
I made a simple table in a new database (one text field, one numeric field with that format), filled it with a few records, exported to xls, opened in Excel, and clicked on the SUM-icon in the taskbar.
Can you try the same?
Kees
Office XP Pro
I've been keeping records in an Access database of people who have booked on courses I teach, including details of their payments. I copied and pasted the data in Xcel in order to do some calculations on it but found to my surprise that Xcel does not recognise the contents of the cells as numerical data and so I cannot do anything with it. I have to replace each figure manually with the same figure before being able to crunch any numbers (i,e I have to delete the figure, say

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic