Date format ad hoc

[nicke32876336]

Why do ad hoc excel exports use text format for dates? 

[TanmayMathur]

Hi,

The date is in text format by design. Let me know if it is hampering your work in any way.

Thanks!

[nicke32876336]

Thanks for the response. If dates can default to date format that would save a lot of time. 

[JillsMatthew · Accepted solution]

Nick Edwards wrote...

Why do ad hoc excel exports use text format for dates? 

Try changing your Font and Locale under Tools >> Settings to English (International) and Calibri Light.

It worked for me

[steven_zimmerma]

I agree with this as well.  It is a quite a pain to go into excel and then convert the text output to date format.