Date and Text string

[joe_stas]

Hi
I have a column of my report that contains data from an excel spreadsheet. The data is in the form of text and dates. For example 'Repaid" or "03/03/2006" (depending on the case).

When I put this in my report none of the dates show up. Is there a way to get both the text and the dates to show withing that column?

Thanks

[jasonli]

before you put it on report, create one formula to convert it to string, and make sure the formula field can get all strings that you want.