Expand my Community achievements bar.

Join us at Adobe Summit 2024 for the Coffee Break Q&A Live series, a unique opportunity to network with and learn from expert users, the Adobe product team, and Adobe partners in a small group, 30 minute AMA conversations.
SOLVED

Date format ad hoc

Avatar

Level 2

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

1 Accepted Solution

Avatar

Correct answer by
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

View solution in original post

4 Replies

Avatar

Level 10

Hi,

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

Thanks!

Avatar

Level 2

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

Avatar

Correct answer by
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

Avatar

Level 1

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.