If your month name is stored as text you can use the MONTH and DATEVALUE Functions to convert the month name, but if the month isn't stored as text than you only need to adjust the formatting Month Name to Number – Formatting If the cell containing the month name is rightaligned then the cell may contain a date (stored as a serial numberFor example, if I have the week number "2" in one cell and the year 12 in another, I want Excel to automatically give the month for that week, January (or 1) in a third cell SELECT NAME ,BIRTHDAY ,CONVERT(VARCHAR(2),BIRTHDAY,1) AS TEST_NUM_MONTH FROM Employees the last query returns month in two digits format 3 Methods for converting a month number to month name As you've seen in the previous example, month number formats are not always the same, for January you can have 1, 01 or other
How To Convert A Date To The Month With Two Digits Excelnotes