Skip to Content
0
Former Member
Oct 19, 2007 at 04:53 AM

When Exporting a Crystal Report to Excel format all of the dates get changed when viewed on Mac version of Excel

147 Views

We're using Crystal Reports 10 and when we export a report from the Crystal Viewer using either the MS Excel 97-2000 option or the MS Excel 97-2000 (Data Only) option, the date columns on the report appear as expected on a PC version of Excel, however, most of the users at our company use Macs so when they open the same report on the Mac version of Excel all of the dates show up as 2011 or 2012 dates eventhough they are suppose to be 2008 dates. We've tried to just open the report after the export process and then do a "Save As" but get the same result. The date columns all appear to be formatted as Date. The dates on the Crystal Viewer appear as expected when viewed on a Mac. The users are running Excel for Mac OS-X Service Release 1.0. Any idea why this may be happening and is there a solution to this problem? Thanks!