#Value! Error on exported Excel file from SSRS rpt

Solution :

  Right click those troubled columns -> choose the text box properties ->  click the Number tab -> highlight number section -> check ‘ Use Regional Formatting’.

This seems to be able to fix the issue

Link: http://social.msdn.microsoft.com/forums/en-US/sqlreportingservices/thread/7aa7f32b-efd5-4f40-914c-ec62f0ee5e0c/