Select a Category

How to format month to short month in Excel 2010?

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”

Reference

Format a date the way you want

[…]