how to format this date type?

Originally Posted by NickyC

to set the format
on the home tab select
format > format cells > custom

type this in the box

yyyy mmm ddd hh:mm

and press ok

I did it, it didn't work... it was formatted wrongly...
Screenshot - 20.06.2017 , 01_43_43.png

please, kindly upload the xls with the date formatted exactly as explained.. so that i don't need to be any other step



thank you