Change date format in Excel

[Closed]
Report
Posts
1
Registration date
Thursday June 21, 2018
Status
Member
Last seen
June 21, 2018
-
Posts
2786
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
August 5, 2021
-
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

1 reply

Posts
19532
Registration date
Wednesday October 8, 2008
Status
Contributor
Last seen
June 15, 2019
1,861
2
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Posts
2786
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
August 5, 2021
470
I would have solved this using a bunch of nested functions, but this is so much easier!

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!