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

Copper 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