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.

JillsMatthewAccepted solution

Level 4

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.

Translate

JillsMatthewAccepted solution

Level 4

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

Translate

Level 2

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

Translate

Employee

Hi,

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

Thanks!

Translate

Sign up