Excel- Convert the date format into general format

Report
Posts
134
Registration date
Thursday May 15, 2008
Status
Member
Last seen
February 27, 2021
-
Posts
2
Registration date
Monday January 11, 2021
Status
Member
Last seen
January 13, 2021
-
Click the link below to learn more about the topic in this thread:

https://ccm.net/faq/24457-excel-convert-the-date-format-into-general-format

Posts
2
Registration date
Monday January 11, 2021
Status
Member
Last seen
January 13, 2021

Thanks for formula.
As an alternative to the Date picker control, I created a userform to enter dates into the active cell. Date can be entered in the cell in two formats as dd.mm.yyyy and mm.dd.yyyy. Also, the date in the cell can be changed according to these two formats.
Day and month names are generated according to the user's system language.

I hope it will be useful to you.

Source : https://eksi30.com/add-date-to-cell-easily-with-excel-userform/

Brilliant!!! THANK YOU!!!

Thank you this tip.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!