EXCEL: How can you FORMAT a serial number into a MONTH ( Jan, Feb)

Question

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

Answer 1

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

Answer 2

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