Converting a Number to a month Name

I am trying to convert numbers such as 01,02,03 to month names like Jan, Feb, Mar.  I am using the formula =text(a1,"mmm") but everything returns Jan.  What am I doing wrong?

Answer
Answer

Hi,

Cell A1 (numbers between 1..12): 2
Formula: =TEXT(DATE(2011,A1,1),"MMM")
Result: Feb

 

Regards,

Frank


If this post answers your question, please mark it for all readers as the Answer or vote if the reply has been helpful.

If this post answers your question, please mark it as the answer or vote it as helpfull.

309 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info


Last updated April 24, 2025 Views 208,110 Applies to: