Page 1 of 1

Download date format

Posted: Wed Apr 14, 2021 2:20 pm
by 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.

Re: Download date format

Posted: Fri Apr 16, 2021 9:21 pm
by 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.