Data in Time format appears in Excel as Datetime

[jannoth]

When I export a report from CRXI to Excel 2007, everything works fine but when a colleage does the same with her CRXI and Excel 2007, the Time field appears as Datetime in Excel.

We're both on the same LAN network (Citrix - so our O/S settings can't be edited and our CR will have the same patches etc). But, program options can be tailored so I've searched everywhere but can't see a difference (I've examined both our programs' options).

Can anyone think of a setting within CR (or elsewhere!) which could cause Time fields to be converted to Datetime when exported from CR to Excel v2007?

Thanks and apologies if I've chosen the wrong forum to post this question.

J

 

[Madawc]

WHen you say 'options' does that include File > Options > Field, where different defaults are sometimes found?

If that's not it, you could try using ToText to turn it into a text field, which can be defined with date or time displays.

Madawc Williams (East Anglia, UK). Using Crystal 11.5 with SQL and Windows XP

 

[jannoth]

Hi Madawc and thanks. I did look in File > Options > Field, yes, and all the Report Options areas too. Both programs have identical options %-)

FYI, I got around the problem this time by creating a new formula which converted the Datetime to Time format then displayed that - as opposed to displaying the actual field then adjusting the format to Time.

But, I still don't know why my Excel showed the field as Time whereas my colleagues converts it to Datetime - we run the same RPT, same CRXI and Excel 2007.

There's no major issue now, as the data in Excel is correctly formatted but I sure would like to know where the setting is saved