Download the example workbook
In this Article
This tutorial will demonstrate how to convert a month name to it’s corresponding number in Excel and Google Sheets.
Convert Month Name to Number
The first question to ask yourself when converting a month name to a number is: Is my month name stored as text?
Month Name to Number – Formatting
If the cell containing the month name is right-aligned then the cell may contain a date (stored as a serial number) with cell number formatting set to month:
Simply change the date format from MMM (abbreviated name) or MMMM (full name) to M (month number, no leading zero) or MM (month number, with leading zero).
You can change the date format from the Cell Formatting Menu:
Type “M” or “MM” in the Type area.
To access the Cell Formatting Menu use shortcut CTRL + 1 or press this button:
Month Name to Number – Functions
Convert Month Name to Number in Google Sheets
All of the above examples work exactly the same in Google Sheets as in Excel.