When I download data sets in Excel that contain a Date, it does not create an Excel “date” but a “general” entry in each date cell - I am using this to test an import feature that requires that “date” entry type and need to click into each cell to get it to flip - any thoughts on how can get the export to give me an actual excel date?
The trick is to output the raw date to excel using the f(x) inline formula feature. Just click the f(x) button on your date column and enter a value of “this.raw”. Here is an example: