Problem

Need to format date in Excel to short month such as 01Feb2014?

Solution

This is a not a standard format. However, one can use custom format in Excel. The code is “ddMMMyyyy”

001 - Format to Short Month

Reference

Format a date the way you want