Forum Discussion

excelfriend583u's avatar
excelfriend583u
New Member
2 years ago
Solved

PowerQuery in Excel, data types

Hello, sometimes when I refresh my table and my query, I get an error message that "2023E"could not be converted into date format. I don't find any reason for this behavior. Maybe someone can help me...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi excelfriend583u ,

    It looks like your raw data was converted to be presented in scientific notation, what does your raw data look like?
    If your original data structure is the same as the data I tested:

    You can directly convert the column to a date type directly when the column's data type is text:


    Best Regards,
    Dino Tao
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi excelfriend583u ,

It looks like your raw data was converted to be presented in scientific notation, what does your raw data look like?
If your original data structure is the same as the data I tested:

You can directly convert the column to a date type directly when the column's data type is text:


Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.