Mega Code Archive

 

Categories / MSOfficeExcel 2007 Tutorial / Text Functions

 

Uses the NOW and TEXT function to format the date and time

Input the formula: =TEXT(NOW(),"mmmm d, yyyy at h:mm AM/PM")