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 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?

E.g.

Date----------Formula---------Result-----What I want!
01/03/2010---Month(Date)--------3----------MAR

Thanks Mike

share|improve this question

2 Answers 2

up vote 2 down vote accepted

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

mmm

this is short month format

EDIT:

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
    mmm

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

 
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.