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
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies