Is it possible to change the date format when exporting to excel?

When exporting date fields from Jira they come over as a alpha numeric date "Jan/06/14"

Is it possible to have it export as only a numerical value such as 01-06-14 or possibly 01/06/2014?

3 answers

Community moderators have prevented the ability to post new answers.

0 votes

Answer accepted

Also reported here, you can use the date format change workaround from Admin panel.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

0 votes

I already had the date format set as "MM/dd/yy" in advanced settings, I totally missed the date and time setting in Look and Feel.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

0 votes

There is a suggestion in this page to use VBA by Michele:

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.