- last edited on
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 time I open the report and refresh the dates are converted to it's numerical equivalent. In Power Query, the columns are seen as Date/Time; therefore, I changed it to 'Date' to see if the Time portion could be causing a problem. That did not help. I'm at a loss as to what the issue is. This does not happen with Excel 2013. I can't find any settings in Excel 365 that might be causing this.
01-07-2020 11:08 AM
@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?
10-04-2020 08:51 AM
1. Right click on target table(s).
2. Hover on the Table menu,
3. Select External Data Properties
4. Check the box next to "Preserve column/sort/filter/layout"