Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

1 Answer 1

up vote 2 down vote accepted

Two ways you can do this:

In E5 use the formula

=E4

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

 
discard

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.