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

Adobe Employee

Hi,

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

Thanks!

Level 2

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

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

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.

Sign up