To convert month names to numbers, you can create a lookup table with the month names and corresponding numbers. Then, use the VLOOKUP function in Excel to find the corresponding number for each month name.