Set WorkRng = Application.InputBox('Range', xTitleId, WorkRng.Address, Type:=8)

VBA: Convert month name to number Sub ChangeNum() Click Insert > Module, and copy the VBA into the module. Hold ALT button and press F11 on the keyboard to open a Microsoft Visual Basic for Application window.Ģ. Method 2: Convert month name to number with VBAġ. If you want to convert a column list of month names to numbers, just drag the fill handle of the formula cell to fill the range you need. Type this formula =MONTH(DATEVALUE(A1&' 1')) ( A1 indicates the cell that you want to convert the month name to number, you can change it as you need) into a blank cell, and press Enter key. Method 1: Convert month name to number with formula. There are two ways that can help you to convert month names to numbers in Excel. Sometimes, you may want to convert the month name to number or the number to month name, such as convert January to 1, in Excel, you can use formulas and VBA to quickly convert between month name and number.Ĭonvert date to month name or month number with Kutools for Excel How to convert month name to number in Excel?

Visual basic for excel day of month