Issues with formatting after downloading or opening a report in SmartView
Here is the situation. I have a report with numbers formatted as thousands. So, $1,000,000 will be presented as $1,000. After I download it to Excel, I will not see $1,000,000 formatted as $1,000 - I will see $1,000. Is there any way to have it downloaded as $1,000,000? Financial Reporting Studio had an option for query-ready downloads that completely ignored formatting, but I don't see it anywhere in Management Reports.
Please advise. Thanks!