Hi everyone, I'm using the export to MS Excel 97-2000(data only) option, but any records on the report where date fields are blank are being populated with '00/01/1900 00:00:00' is there anyway around this issue? I've also tried selecting the export to MS Excel 97-2000 and by doing so the formatting of the report in Excel is messed up but the date fields have no data. The problem is that there that many fields in the report that I cant display them properly within Crystal so they are all minimised so they'll fit within the report.

Any help would be appreciated!