Excel- Convert the date format into general format

September 2017

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.

Related

Published by aakai1056. Latest update on March 29, 2012 at 10:48 AM by aakai1056.
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).