# How to Convert Month Name to Number in Excel (5 Suitable Ways)

Get FREE Advanced Excel Exercises with Solutions!

In terms of working with Microsoft Excel, we might face the necessity of converting month name to number. There is no need to panic. We can do it quite simply. For this, we just need to follow some sequential procedures. In this article, I am going to discuss 5 effective ways on how to convert month name to number in Excel. I hope it will be easy to understand and then, apply later.

## 5 Suitable Ways to Convert Month Name to Number in Excel

There are so many quick, effective, and simple ways to convert month name to number. I am going to discuss 5 of them in this article.

For more simplification, I am going to use a dataset where I have some month names in a column with a serial number column. I am going to convert the month name to number in the Month Number column.

### 1. Use MONTH Function

We can use a built-in function named the MONTH Function to convert month name to number. Just follow the following steps to execute the purpose.

Steps:

• Select a preferred location first. I have chosen cell D5 for this purpose.
• Next, input the following formula in that cell.
`=MONTH(C5&1)`

• Press ENTER to have the converted output.

### 2. Combine MONTH & DATEVALUE Functions

A combination of MONTH and DATEVALUE functions can be another effective way to convert month name to number.

Steps:

• Pick a cell and write the formula mentioned below in that cell.
`=MONTH(DATEVALUE(C5&1))`

• After that, hit the ENTERÂ button.

• AutoFill the rest cells.

### 3. Apply MONTH Function with Symbol

In order to convert month name to number, we can also apply the MONTH function with Double Hyphen (â€“) symbol. You can follow the following procedure to do it perfectly.

Steps:

• Firstly, select a cell and input the formula mentioned below in that cell.
`=MONTH(--(C5&1))`
• To have output, press ENTER.
• For the remaining cells, use AutoFill.

The MATCH function can be another handy function to convert month name to number. Just follow the following steps in a sequence.

Steps:

• Select a preferred location first. I have chosen cell D5 for this purpose.
• Next, input the following formula in that cell.
`=MATCH(C5,{"January","February","March","April","May","June","July","August","September","October","November","December"},0)`

• Next, press ENTER.

• Lastly, apply AutoFill for the remaining cells.

### 5. Use TEXT Function

We can also use the TEXT Function to fulfill our purpose of converting month name to number.

Steps:

• Pick a cell and write the formula mentioned below in that cell.
`=TEXT((C5&1),"m")`

• Along with that, hit the ENTERÂ button.

• Finally, use Fill Handle to AutoFill the rest cells.

## Practice Section

For more expertise, you can practice here.

## Conclusion

At the end of this article, I like to add that I have tried to explain 5 effective ways on how to convert month name to number in Excel. It will be a matter of great pleasure for me if this article could help any Excel user even a little. For any further queries, comment below. You can visit our site for more articles about using Excel.

## Related Articles

#### Naimul Hasan Arif

Hello, I am Arif. I am an Engineer who graduated from BUET. I want to pursue an enterprising career in a progressive environment where my skills & knowledge can be enhanced to their maximum potential to contribute to the overall success and growth of the organization.

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF