Formatting is lost when exporting to Excel from the web

When exporting a report to Excel from the planning web then trying to open the exported report in SmartView, formatting is lost especially commas and negative values. How can we preserve the report formatting when opening an exported report in SmartView? Should this be considered a defect or expected behavior (a feature)?”