Convert DD/MM/YYYY to MMM/DD

[Muthukrishnan V]

MS Excel 2007.

Column B contains dates in DD/MM/YYYY format. I need to convert the dates

into MMM DD format. Year not required. Request formula.

Example: 13-02-1952 to show Feb 13.

 

[ahennema]

MS Excel 2007.

Column B contains dates in DD/MM/YYYY format. I need to convert the dates

into MMM DD format. Year not required. Request formula.

Example: 13-02-1952 to show Feb 13.

Just change the number formatting from DD/MM/YYYY to MMM DD. You can have the second column equal the first column but just use the MMM DD formating. Pick by right clicking and select Format Cells/Custom and type in MMMM DD

 

[Muthukrishnan V]

Thank you, Mr Ahennema.