Can someone please help me find, built into Excel (any version) a ready-made format for Date/Time like: MM/dd/yyyy hh:mm AM/PM
I can't imagine this is not a common format? 10/05/2018 05:03 PM I like the zero-padded single-digits, and the 4-digit year, yet nowhere in the "Date" format list or the "Custom" format list does anything close exist.
Every time I need to format a date/time column in Excel I need to hand type that format string in.
EDIT: Based on the responses, which I do appreciate--I need to clarify the question. I know how to select ranges and choose formats, etc. I was just bewildered that of all the formats available in Excel's list in the Format Cells dialog--none of them were what I would consider a very common Date/Time format (if not the most common in the US--and the default locale format in the US). I thought I may have been digging too deep and that there was some hot-key for "Default Locale DateTime" format.
Thanks for any help on this.