I am trying to create a new column (Column G) showing the month job applications were sent in from the dataset shown in the image below using the Text function in excel

However, I noticed that once the date format changed in Column B (row 13131), I was no longer able to generate application month, but was instead given a repeat of what is in Column B. Is there an efficient way of resolving this without having to manually reformat Column B one by one. I have tried formatting the column as a whole but that didn't work.

CodePudding user response：

Based on your answer to my question, no it's not the issue, I was just checking. You might be able to resolve the issue if you use 'Text to Columns'. It's a great feature. I would suggest selecting column B from row 13131 down to the bottom. Use 'Text to Columns' on the 'Data' part of the Ribbon. When you get to step 3, choose 'Date' under 'Column data format' and then 'MDY' as the format.

Hopefully this works for you, it's usually pretty good.