Date column not changing its format when imported from a text file

  • I would bring the text tile into Power Query which is called Get and Transform Data in later versions of Excel. Once in the PQ Editor, you can change the date from text to Date format.

    External Content
    Content embedded from external sources will not be displayed without your consent.
    Through the activation of external content, you agree that personal data may be transferred to third party platforms. We have provided more information on this in our privacy policy.

  • You say : "While turning text to columns I change the type to date DMY" - that is not the way it works .... you are supposed to choose the date type of the data coming in, and NOT what you are wanting to change it to. (if I'm understanding your comment correctly, of course).

    Cheers, Glenn.

    Beauty is in the eye of the beer-holder.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!