Home

Formatting a cell column to date and time stamp: e.g. 3 Mar 19 11:15 format. month abbreviation

%3CLINGO-SUB%20id%3D%22lingo-sub-833269%22%20slang%3D%22en-US%22%3EFormatting%20a%20cell%20column%20to%20date%20and%20time%20stamp%3A%20e.g.%203%20Mar%2019%2011%3A15%20format.%20month%20abbreviation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-833269%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20-%20I%20would%20like%20to%20know%20how%20I%20can%20format%20a%20%3CFONT%3Ecell%2F%20column%20to%20%3CU%3E%3CSTRONG%3Edate%20and%20time%20stamp%3C%2FSTRONG%3E%3C%2FU%3E%3A%20e.g.%20%3CFONT%20color%3D%22%23ff0000%22%3E3%20Mar%20'19%2011%3A15%3C%2FFONT%3Eformat%20(the%20month%20abbreviation%20spelled%20out).%20To%20avoid%20the%20confusion%20about%20what%20is%20the%20month%20and%20what%20is%20the%20date.%20Does%20anyone%20know%20how%20to%20do%20that%3F%20thank%20you%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-833269%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-833290%22%20slang%3D%22en-US%22%3ERe%3A%20Formatting%20a%20cell%20column%20to%20date%20and%20time%20stamp%3A%20e.g.%203%20Mar%2019%2011%3A15%20format.%20month%20abbreviation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-833290%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F402053%22%20target%3D%22_blank%22%3E%40Ronald_Daas%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20try%20the%20following%20format%20under%20custom%20format.%3C%2FP%3E%3CP%3Ed%20mmm%20'yy%20hh%3Amm%20AM%2FPM%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-833607%22%20slang%3D%22en-US%22%3ERe%3A%20Formatting%20a%20cell%20column%20to%20date%20and%20time%20stamp%3A%20e.g.%203%20Mar%2019%2011%3A15%20format.%20month%20abbreviation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-833607%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%20-%20worked%20and%20indeed%20very%20simple.%20thank%20you%20again%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F368896%22%20target%3D%22_blank%22%3E%40Kodipady%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-833944%22%20slang%3D%22en-US%22%3ERe%3A%20Formatting%20a%20cell%20column%20to%20date%20and%20time%20stamp%3A%20e.g.%203%20Mar%2019%2011%3A15%20format.%20month%20abbreviation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-833944%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F402053%22%20target%3D%22_blank%22%3E%40Ronald_Daas%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20glad%20it%20helped%20%2C%20Ronald!!%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Ronald_Daas
New Contributor

Hello - I would like to know how I can format a cell/ column to date and time stamp: e.g. 3 Mar '19 11:15 format (the month abbreviation spelled out). To avoid the confusion about what is the month and what is the date. Does anyone know how to do that? thank you

3 Replies

@Ronald_Daas 

Please try the following format under custom format.

d mmm 'yy hh:mm AM/PM

Thank you - worked and indeed very simple. thank you again @Kodipady 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies