Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2008 Forums  Analysis Server and Reporting Services (2008)  number to month name is corrupt on export to excel

Author  Topic  kT555 Starting Member 1 Post Posted - 2009-03-11 : 08:07:13 In SQl Server reports, I have a matrix with a column which is a numeric field.I am then formatting the field using month name =MonthName(Fields!RefurbCompleteMonth.Value).. this shows up the full month name on the report - but when i export to excel some month names show correctly, others show as eg F1900bruary, so the excel columns look like January F1900bruary March the actual data in the excel cell shows as 1 02/01/1900 3 I removed the month name formating and re exported and i get the following in excel cells 1 2 3 which leads me to believe it is something to do with the month name formatting... I have also checked the data for anything corrupt and all looks fine Any ideas appreciated ? UPDATE *** it relates to the letter E in the month names - so september looks like s1900pt1900mb1900r??