» Converting a Month's Serial Number into Its Corresponding Name
CATEGORY - Excel Date & Time Formulas
VERSION - All Microsoft Excel Versions
Converting each month's serial number, as shown in column A, into its corresponding name.
Solution 1:
To return a month's full name, use the TEXT function as shown in the following formula:
=TEXT(A2*29,"mmmm")
To return the first three letters of a month's name ("Jan", "Feb" etc.), use the TEXT function as shown in the following formula:
=TEXT(A2*29,"mmm")
Solution 2:
Use the CHOOSE function as shown in the following formula:
=CHOOSE(A2,"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec")
Book Store:
Recommended Books:
- The McGraw-Hill Guide to Writing a High-Impact Business Plan: A Proven Blueprint for First-Time Entrepreneurs
- The Fall of Advertising and the Rise of PR
- Microsoft Word Version 2002 Inside Out
- Adventure Capitalist: The Ultimate Road Trip
- Special Edition Using Microsoft Access 2002
- The Sweet Potato Queens' Big-Ass Cookbook and Financial Planner
Converting a Month's Serial Number into Its Corresponding Name
Great advice - thank you
Converting value to text month
Mark Jennings
I was searching different places how to convert a numeric value to the text month name, this is the only place I found what I needed. Thank you!! This was helpful!!
Converting value to text month
Aindril De
if you have to cut the month serial no out of a date and then convert:
You can try:
=TEXT(month(A2)*29,"mmm")
Choose didn't work as written
Dick Copple
I had to convert A2 in the Choose function using the =month(A2) function in place of A2 to get it to work.
Question, why does Solution 1 need to use the multiplier (*29) to make the text function work?
Thanks,
Dick
justin-uk
You don't need the *29 there for it to work. The formula
=TEXT(A1,"mmmm yyyy")
works just fine. What is surprising is that the *29 seems to make no difference!
