I need to make a formula that will reformat a date in excel. My content is as below:
 Cell E4: 2/15/2012
I would like column E5 to be like this:
 Cell E5: 15 February 2012
Is there an easy way to do this? Thank you all!
Best, Brandon
I need to make a formula that will reformat a date in excel. My content is as below:
I would like column E5 to be like this:
Is there an easy way to do this? Thank you all! Best, Brandon 


Two ways you can do this: In E5 use the formula
and then reformat E5 like this Format Cells > Number > Custom and in the "Type" box paste this
or you can use this formula in E5
The first one produces a formatted date  the second one (although it looks the same) produces a text string that looks like a date. You don't really need an extra cell, though  you could simply apply the custom format to your original date in E4 

