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
Related
- Convert date to general in excel
- How to change date format to general in excel - Best answers
- How to convert date to general in excel - Best answers
- How to convert number to words in excel in rupees without vba ✓ - Forum - Excel
- Convert number to words in excel without currency - How-To - Excel
- Formula in Excel to turn numbers into text ✓ - Forum - Excel
- How to convert number to words in excel in rupees ✓ - Forum - Word
- How to convert number to words in excel in rupees spellnumber ✓ - Forum - Office Software
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).
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/