Visual Studio 2005 & SQL Reporting Services

I'm querying an Excel spreadsheet and creating a report from that.

Here's the problem: in the Excel spreadsheet I have a column of data that is formatted as Custom mmmm-yy. However, there are both dates and text in that column.

When previewing the report in VS 2005, the report shows only the text.

When deploying the report to Reporting Services, the report only shows the dates.

I need to display both.

Suggestions or ideas?