Excel's VALUE function has only one argument: where a is the value stored as text that you want to convert into a number.
1. Drag the Fill Handle of a single cell to copy that cell. The Fill Handle is at the bottom right of any selected cell or group of cells. 2. Drag the Fill Handle of a cell containing January, Jan, ...