A few words of thanks would be greatly appreciated.

Excel- Convert the date format into general format

Latest update on March 29, 2012 at 10:48 AM by aakai1056 .

Issue

Under Excel 2003, how do I convert the date (3/21/2012) from date format into general format and still keep it show as 3/21/2012 instead of 40989 in the cell?

Solution

Try this formula :

=TEXT(A2,"mm/dd/yyyy")

Thanks to hhchavez for this tip.

Convert date to general in excel
How to convert date to general in excel - Best answers
Excel convert date to general - Best answers
Convert number to words in excel - How-To - Excel
How to convert number to words in excel in rupees ✓ - Forum - Excel
Convert ml to oz in excel - Forum - Excel
Convert yyyymmdd to date in excel ✓ - Forum - Excel
Convert number to words in excel 2007 indian rupees formula ✓ - 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).

Excel - A macro to edit file name

Excel - Update calculations