As shown in the figure, the date contains date and time. We now need to remove the time and keep only the date.
Specific method:
Select the time column, then select the "Data" and "Column" options
Select "Fixed width" in the column text wizard, and then select Next
Determine the position of the column line.
We need to save the year, month and day, so the column line should be after the year, month and day without modification.
We don’t need time, you just need to select hours, minutes and seconds, then select “Skip without importing this column”, and then select Done. Note that you need to select the time first, and then choose not to import this column to skip it.
This is done.
Recommended tutorial: excel tutorial
The above is the detailed content of How to remove time after date in excel. For more information, please follow other related articles on the PHP Chinese website!