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 extract the Month() number out of my date. I now want to change that number into a recognisable string Jan, Feb, Mar, etc. In Access you can use FORMAT, but what can we use in Excel?


Date----------Formula---------Result-----What I want!

Thanks Mike

share|improve this question
up vote 2 down vote accepted

You can Format Cells (right click on cell you want to format) -> Category:Custom and type:


this is short month format


what I wrote would work on full date not on a single number, so if you do not need to go through all the steps (especially the =MONTH formula) this could be the answer

share|improve this answer
I think this is the correct answer. If you need the date and month next to each other, instead of =month(datecell) just make it =datecell and change the custom formatting as described in this answer. – Sux2Lose May 20 '10 at 14:00
I sued the simple =Datecell and then formatted "mmm" in custom formats. So simple I forgot to do it. It's had the added benefit of organising the dates as well when I add mmm-yy to the format! Bonus. – RocketGoal May 20 '10 at 15:05

You can format your date (in cell A1) to a text string using the formula:

=TEXT(A1, "mmm")

or you can leave it as a number but format it as a month:

Format Cells
  Category: Custom

The month formats you can use are:

mmmm - Full month name
mmm - Abbreviated month name
mm - numeric month, zero padded
m - numeric month
share|improve this answer
The problem I see with this answer is that sorting by the month column will be alpha based instead of numerical. Therefore April will come before March, etc. – Sux2Lose May 20 '10 at 14:03
Comprehensive answer. Thank you for your time. I used the solution below, but yours is one that had helped me use TEXT (which I will come back to I'm sure) – RocketGoal May 20 '10 at 15:06

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.