I have a report with columns for each month and year. The formula for the column heading is monthname(month(datefield)) + " " + totext(datepart("yyyy",datefield)).  I have also used year(datefield) instead of datepart. When I run the report in Crystal, I get a nice column name like January 2012.  However, when I export to Excel, I get January 2,012.00 !  I have tried any number of things and cannot get it to export properly. It isn't exporting a number so why would it interpret that part of a formula field as a number?

Thanks very much! I'll try that!