Formatting lost when exporting report from Access to Excel

[Kathy]

I have a report that is calculated and formatted in
Access with 1 level of grouping, totals in group footer.
When exported to Excel, I lose all formatting and the
group footer totals in the report? Please Help!

Thanks
Kathy