How to Convert Month Number to Month Name in Excel

How To Convert Month Number To Month Name In Excel
In Excel, you can convert a month number to a month name using the TEXT function or the TEXT function in combination with the DATE function. Here are two ways you can use:

Procedure 1: Using the TEXT Function
Assuming the month number is in cell B3, you can use the following formula:
=TEXT(DATE(2023, B3, 1), "mmmm")
This formula uses the DATE function to create a date with the specified month number and the year 2023 (you can change the year as needed). The TEXT function then formats this date as the full month name ("mmmm").

Procedure 2: Using the CHOOSE Function
Another method is to use the CHOOSE function to create an array of month names and then select the appropriate one based on the month number:
=CHOOSE(B3, "January", "February", "March", "April", "May", "June", "July", "August", "September", "October", "November", "December")

In this formula, B3 is assumed to contain the month number. The CHOOSE function then selects the corresponding month name from the list.
This is how you convert number to month in excel. Choose the method that best fits your needs or is more convenient for your specific situation.
#Excel #Function #MonthName


Thanks for watching.
----------------------------------------------------------------------------------------
Support the channel with as low as $5
  / excel10tutorial  
----------------------------------------------------------------------------------------
Please subscribe to #excel10tutorial
https://goo.gl/uL8fqQ

Here goes the most recent video of the channel:
https://bit.ly/2UngIwS

Playlists:

Excel Tutorial for Beginners: https://goo.gl/UDrDcA
Intermediate Excel Tutorial: https://tinyurl.com/59a837py
Advance Excel Tutorial: https://goo.gl/ExYy7v
Excel Text Case Conversion Techniques: https://goo.gl/xiP3tv
Combine Workbook & Worksheets: https://bit.ly/2Tpf7DB
All About Comments in Excel: https://bit.ly/excelcomments
Excel VBA Programming Course: http://bit.ly/excelvbacourse
ChatGPT Excel Mastermind: https://tinyurl.com/46kn7tmd

Social media:
Facebook:   / excel10tutorial  
Twitter:   / excel10tutorial  
Blogger: https://excel10tutorial.blogspot.com
Tumblr:   / excel10tutorial  
Instagram:   / excel_10_tutorial  
Hubpages: https://hubpages.com/@excel10tutorial
Quora: https://bit.ly/3bxB8JG
Website: https://msexceltutorial.com/ Become a member and enjoy exclusive perks while supporting the channel you love!
   / @excel10tutorial