Excel: Convert DateTime Column to Text
insights Stats
warning Please login first to view stats information.
toc Table of contents
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)
copyright
This page is subject to Site terms.
comment Comments
No comments yet.