Excel: Convert DateTime Column to Text

TEXT function can be used in Excel to convert DATETIME column to a text column with provided format.

Code snippet

=TEXT(A1,"YYYY-MM-DD HH:mm:ss")

To YYYY-MM-DD

=TEXT(A1,"YYYY-MM-DD")

To AM/PM

=TEXT(A1,"YYYY-MM-DD HH:mm:ss AM/PM")

More format

TEXT function - Office Support (microsoft.com)