Question: how to change date format in excel text to column?
Answer: Using the Text to Columns Feature to Change the Format Start by selecting all of the text that you want to convert to dates. To do this quickly, select your first cell of data at the top of a column and then hit Ctrl + Shift + ↓ .