Date format ad hoc

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Best answer by JillsMatthew

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

New Participant

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.

JillsMatthewAccepted solution

New Participant

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

New Participant

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

Employee

Hi,

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

Thanks!

Sign up