Here is how to convert a text date to one of the many Excel Date formats ... even when you add or delete rows. There are a number of formulas you can use in column A that will return a row number. The ...