Report

Date format nightmare [Solved]

Ask a question Webill 2Posts Friday February 5, 2016Registration date February 5, 2016 Last seen - Last answered on Feb 5, 2016 01:16PM
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
See more 
Helpful
+0
moins plus
thanks for the tip
Add comment

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!