Thank you for looking at my question.
We have a report on SRSS that lists transactions in a range off currencies, GBP, USD, AED.
The formatting of the report cell containing the currency value is handled using an expression:
=Fields!CurrencySymbol.Value & "#,##0.00"
where the column CurrencySymbol is a char(3) field.
On the report, when previewed on the report server or viewed via a web browser the currency values all are preceded by the relevant currency symbol eg £150.00, $99.00, AED500.00 but when I export the report to Excel I get an error messsage about some number fields losing their formats - specifically the AED values lose their prefix, all other values are OK.
I tried exporting the report as a csv file and the formatting remains as it should.
How can I retain the formatting for all values?