Change date format in Excel

kathycrooks 1 Posts Thursday June 21, 2018Registration date June 21, 2018 Last seen - Jun 21, 2018 at 01:16 AM - Latest reply: TrowaD 2395 Posts Sunday September 12, 2010Registration date July 17, 2018 Last seen
- Jun 26, 2018 at 11:55 AM
hi there
i just need to make 1 cell for a date but with auto population of slashes
so if i type 21062018 in the cell it comes up like 21/06/2018

is that possible??

many thanks
See more 

Your reply

2 replies

Best answer
xpcman 19103 Posts Wednesday October 8, 2008Registration dateModeratorStatus July 17, 2018 Last seen - Jun 22, 2018 at 12:06 PM
2
Thank you
I suggest you read this FAQ:

https://ccm.net/faq/28938-change-date-format-in-excel

Thank you, xpcman 2

Something to say? Add comment

CCM has helped 1690 users this month

TrowaD 2395 Posts Sunday September 12, 2010Registration date July 17, 2018 Last seen - Jun 26, 2018 at 11:55 AM
I would have solved this using a bunch of nested functions, but this is so much easier!
Respond to xpcman