Cross Tabs exporting to Excel

[phellis]

I've have reports that contain numeric values which export to excel (data only) and maintain their data format as numerics.
However when i export a report to excel (data only) that contains a cross tab then the numeric values are reformatted in excel as characters.
I've also found this to be true of date within the cross tab.

Has anyone else come across this and do yu know how to fix it.

Thanks