Forum Discussion
PowerQuery Date/Time formating issue
I am having issue with the way date/time is formatted when in excel, looks fine in PowerQuery but then when i load into excel its messed up in PowerQuery it shows as 11/25/2022 8:45:59pm when i ...
What you are seeing is the date/time as an Excel serial number. You just need to format the cell(s) in Excel as date/time or use a custom format like d/mm/yyyy h:m:s
Read more info on Excel Date and Time
Regards
Phil
thank you, and by manually changing the format to the column in excel does work, but then when i refresh the data again and reload to excel, i have to manually change it again... not sure if there is a setting i am missing so that when i close and load it keeps the data type for that column