5
Thanks

A few words of thanks would be greatly appreciated.

Excel- Convert the date format into general format

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.
5
Thanks

A few words of thanks would be greatly appreciated.

Ask a question
CCM is a leading international tech website. Our content is written in collaboration with IT experts, under the direction of Jean-François Pillou, founder of CCM.net. CCM reaches more than 50 million unique visitors per month and is available in 11 languages.

Related

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).
2 vote - 5.0/5

2 Comments


Brilliant!!! THANK YOU!!!

Thank you this tip.