Current location - Plastic Surgery and Aesthetics Network - Plastic surgery and medical aesthetics - How to replace all dates in excel with other dates?
How to replace all dates in excel with other dates?
1. Select the table, and then click Data-Select Column Options.

2. Select the delimiter in the Text Sorting Wizard 1, and then click Next.

3. Select the default value in the Text Sorting Wizard 2, usually the tab key. Next.

4. Select the date mdy to end in the text sorting wizard 3.

5. Finally, see if the date format has become a real date.