Previous Topic Next Topic

Change date format in Excel

Closed
kathycrooks Posts 1 Registration date Thursday June 21, 2018 Status Member Last seen June 21, 2018 - Updated on Jun 21, 2018 at 03:46 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - 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
Related:

1 response

Answer 1 / 1
xpcman Posts 19530 Registration date Wednesday October 8, 2008 Status Contributor Last seen June 15, 2019 1,828
Jun 22, 2018 at 12:06 PM
I suggest you read this FAQ:

https://ccm.net/faq/28938-change-date-format-in-excel
2
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Jun 26, 2018 at 11:55 AM
I would have solved this using a bunch of nested functions, but this is so much easier!
0

Similar discussions

Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses