Home

Date value changes to text on refresh of Power Query data - only for Excel 365

wowcow73
New Contributor

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.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies