Kontext Copilot - An AI assistant for data analytics. Learn more
Expression of Interest
Excel: Convert DateTime Column to Text
insights Stats
warning Please login first to view stats information.
Raymond
Code Snippets & Tips
Code snippets and tips for various programming languages/frameworks. All code examples are under MIT or Apache 2.0 license unless specified otherwise.
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.