Convertir une cellule date-heure en date seule

Solved
gelomaak Posted messages 14 Status Membre -  
Vaucluse Posted messages 27336 Registration date   Status Contributeur Last intervention   -
Hello,

I would like to know, please, how to remove the time linked to the date in Excel. I have a file with a column containing dates in the format yyyy-mm-dd hh:mm:ss as indicated below. I want to duplicate my table into another file, but I want the date column in the new table to be pasted in the following format: yyyy-mm-dd (that is to say, without the time).

Thank you in advance.

Here is an example of the series.

2018-04-24 14:35:09
2018-04-24 09:09:22
2018-04-23 11:27:00
2018-04-23 10:48:08
2018-04-23 08:40:02
2018-04-20 15:39:18
2018-04-20 14:54:54
2018-04-20 13:33:41
2018-04-20 11:16:39
2018-04-19 14:24:59
2018-04-19 14:21:25
2018-04-19 14:19:34
2018-04-19 14:15:51
2018-04-19 13:08:54
2018-04-19 10:41:39
2018-04-18 11:49:02
2018-04-18 11:00:58
2018-04-17 13:00:40
2018-04-17 12:14:04
2018-04-17 08:10:32
2018-04-17 07:59:28
2018-04-16 14:11:27
2018-04-16 14:07:42
2018-04-16 14:06:15
2018-04-16 14:04:44
2018-04-16 14:02:07
2018-04-16 13:49:22
2018-04-16 13:46:21
2018-04-16 13:44:37
2018-04-16 13:42:50
2018-04-16 13:40:36
2018-04-16 13:38:17

--

2 réponses

Raymond PENTIER Posted messages 58546 Registration date   Status Contributeur Last intervention   17 474
 
Select the new column and set it
to date format 14/03/12
or to custom format yyyy-mm-dd
Retirement is great! Especially in the Antilles...
Raymond (INSA, AFPA)
0
gelomaak Posted messages 14 Status Membre
 
Hello,

This method did not work. The new column still displays the hours.

Thank you for your input.
0