Copying figures from Access to Excel
 

I am running Office 2002. When I tried to copy figures from a crosstab query in Access into Excel, the figures come in as text. This doesn't happen when using Office 2000 (on another PC). There is a convoluted way of converting the text to figures. However, is there a way of preventing this happening i.e. that the figures would copy to Excel as figures. Perhaps some setting need to be changed. Any help welcome.

mjd