Matt

Format the cell with a custom data format "mmm". You can do that in
the cell that contains the date, or in the cell that has the =MONTH()
function but you need to skip the =MONTH() function and have that cell
equal the cell with the date rather than the MONTH of the cell with
the date, as long as you format the final cell with "mmm". Once you
convert to a month number (1-12) you will always get Jan when you
format is as "mmm".

Good luck.

Ken
Norfolk, Va


On May 16, 3:58*pm, Matt S wrote:
How do I get Excel to display Jan instead of 1 - Nov instead of 11, etc. *as
the result for my = MONTH ( ) function? *