Forum Discussion
Date value changes to text on refresh of Power Query data - only for Excel 365
I have an issue where my date columns are transforming to numbers and defined as 'general' when I refresh the data. I've tried formatting the entire column as date and saving the file. The next tim...
wowcow73- I'm experiencing the same issue. For me, it seems to loose formatting on all 'newly added' records at the bottom of the table. As an interim solution, I created a macro to use Format Painter to copy the 1st row's format to the rest of the table.
** Is ANYONE from MICROSOFT monitoring this forum & issue?