Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

share|improve this question
up vote 2 down vote accepted

Two ways you can do this:

In E5 use the formula


and then re-format E5 like this

Format Cells > Number > Custom and in the "Type" box paste this

d mmmm yyyy

or you can use this formula in E5

=TEXT(E4,"d mmmm yyyy")

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

share|improve this answer
Thank you very much!!! – Brandon Dec 8 '12 at 0:31

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.