Skip to main content
nicke32876336
Level 2
Dec 16, 2015 2:00 PM UTC
Solved

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
Dec 17, 2015 4:57 PM UTC

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

4 replies

TanmayMathur
Adobe Employee
Adobe Employee
Dec 17, 2015 2:52 PM UTC

Hi,

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

Thanks!

Translate
nicke32876336
Level 2
Dec 17, 2015 3:45 PM UTC

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

Translate
JillsMatthewAccepted solution
Level 4
Dec 17, 2015 4:57 PM UTC

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
Mar 22, 2016 10:41 AM UTC

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