Select a blank cell, enter below formula, and press the Enter key. ), Excel - Convert Text Month to the Month Number, Unable to Unhide Columns or Rows in Excel. This is the solution that worked for me to identify a problem with a non-date value in a 1.5 million row CSV file. Join over 4,700 subscribers and be the first to find out about free Excel webinars plus special online Excel training offers. in col. C mean?