Excel- Convert the date format into general format

Ask a question

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.

Excel - A macro to edit file name
Excel - Update calculations