I am doing an end to end Data Analytics project, for that I have a data set.

This data set has date column where many dates are in unstructured format (ie 31/1/19) how can I convert it into a standard format (ie 1-31-2019)

CodePudding user response：

Through the Format menu on the top

CodePudding user response：

1. Select the cells you want to format.
2. Press CTRL 1.
3. In the Format Cells box, click the Number tab.
4. In the Category list, click Date and then choose a date format you want in Type.
5. Click OK

Visit