Forum Discussion
Solved
Power query strips decimals when importing decimal date
Hi, I have an .xls data source with decimal datetime data eg: 44834.3877777778 and I want it to show it as 30/09/2022 09:18:24 But when I import into power query the decimals are already gone...
Oh my wow. I got into work this morning and it's working now.
I started from scratch on the job, slightly different approach, but basically the same thing. All the times are there now. Huh. The universe must have it in for me this week.
Oh my wow. I got into work this morning and it's working now.
I started from scratch on the job, slightly different approach, but basically the same thing. All the times are there now. Huh. The universe must have it in for me this week.