Excel- Convert the date format into general format
April 2018
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
- Convert date to general in excel
- Excel convert date to general
- Excel date general format
- Converting date to year and month text (Solved) » Forum - Office software
- How to convert Date to word in excel [Solved] (Solved) » Forum - Excel
- Convert Date into English Words in EXcel [Solved] (Solved) » Forum - Word
- Convert Date Format to dd/mm/yyyy in Excel » How-To - Excel
- Converting date format in excel sheet [Solved] (Solved) » Forum - Excel