Mar 29, 2012 · 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? Try this formula : =TEXT(A2,"mm/dd/yyyy") Thanks to hhchavez for this tip....

Excel VBA - Convert Text Date with 2-Digit Year in to real date . Hi I have some CSV raw data. After i used text to column, in the date column, there are one or two converted in text format. Excel shows it as Text Date with 2 Digit Year , looks like "dd/mm/yy". Is there any macro that can convert these ones into date format like "dd/mm/yyyy".