Download date format

[Gustav Clark]

Is it possible to specify the date format in downloads? The default seems to be yyyy-mm-dd, which at least my version of Excel does not recognise as a date.
Gustav

[AndyAmphlett]

Specifying date format can't be specified that I can see; Tom would have to advise. But you can convert the text format date to date format.

Insert an additional column.
Use the formula =datevalue() to generate the date in number format.
Select the resulting cells and right click Format cells > Date
Copy the results and use paste values back into the same cells.
You now have the cells in date format.

Hope that helps.

Andy.