Previous Topic Next Topic

Date format nightmare

Solved/Closed
Webill Posts 2 Registration date Friday 5 February 2016 Status Member Last seen 5 February 2016 - 5 Feb 2016 à 07:42
xpcman Posts 19528 Registration date Wednesday 8 October 2008 Status Contributor Last seen 15 June 2019 - 5 Feb 2016 à 13:16
solved with this:

Because it is not a date to excel.

1. Select the column in which there was date
2. Goto data and choose text to column
3. choose delimited and click next
4. uncheck all and click next
5. click on date and choose right data format of the date that you currently have. It seems that you have DMY, Chose that and finish

This will transform the cells to date

Now format the date as you wish
Related:

1 response

Réponse 1 / 1
xpcman Posts 19528 Registration date Wednesday 8 October 2008 Status Contributor Last seen 15 June 2019 1,824
5 Feb 2016 à 13:16
thanks for the tip