Excel- Convert the date format into general format

December 2016

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 :

This document entitled « Excel- Convert the date format into general format  » from CCM (ccm.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.