Excel: Convert DateTime Column to Text

event 2021-08-18 visibility 276 comment 0 insights
ios_share
Twitter Facebook LinkedIn
more_vert
insights Stats
Raymond Raymond
Raymond
Raymond
articleArticles 578
imageDiagrams 58
commentComments 303
loyaltyKontext Points 6373
 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")

20210818100343-image.png

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)


More from Kontext
comment Comments
No comments yet.

Please log in or register to comment.

account_circle Log in person_add Register

Log in with external accounts