6
Thanks

A few words of thanks would be greatly appreciated.

Excel- Convert the date format into general format

In this short article we will show you how to convert the date from date format into general format and still keep it shown under Excel 2003.

Solution

Try this formula :
=TEXT(A2,"mm/dd/yyyy")


Foto: © Unsplash
6
Thanks

A few words of thanks would be greatly appreciated.

Ask a question
CCM is a leading international tech website. Our content is written in collaboration with IT experts, under the direction of Jean-François Pillou, founder of CCM.net. CCM reaches more than 50 million unique visitors per month and is available in 11 languages.
Related
This document, titled « Excel- Convert the date format into general format », is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (ccm.net).
3 vote - 5.0/5
3 Comments
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!