Mega Code Archive

 

Categories / MSOfficeExcel 2007 Tutorial / Text Functions

 

=TEXT(3152005,mmddyyyy)

Input the formula: =TEXT("3/15/2005","mm/dd/yyyy")