The custom number format section is to format dates. Excel does not recognize your string as date but as a text string, so in order to convert it to a date you'll need a formula. Once excel has a date; then you can use the custom format and show it whichever way you see fit. Hope this made it clear why you cannot format your text string.