Uses the NOW and TEXT function to format the date and time. : TEXT « Text functions « Microsoft Office Excel 2007 Tutorial






  1. Microsoft Office Excel 2007 Tutorial
  2. Text functions
  3. TEXT
Input the formula: =TEXT(NOW(),"mmmm d, yyyy at h:mm AM/PM")
Input the formula: =








22.22.TEXT
22.22.1.TEXT(value,format_text) formats a number and converts it to text
22.22.2.=TEXT(1234.56,"#.#") (1)=TEXT(1234.56,
22.22.3.=TEXT(1234.56,"$#") (3)=TEXT(1234.56,
22.22.4.=TEXT(0.4,"#%")=TEXT(0.4,
22.22.5.=TEXT("3/15/2005","mm/dd/yy")=TEXT(
22.22.6.=TEXT("3/15/2005","mm/dd/yyyy")=TEXT(
22.22.7.=TEXT("3/15/2005","mmm-dd")=TEXT(
22.22.8.TEXT(A1,"$#,##0.00")TEXT(A1,
22.22.9.TEXT(AVERAGE(A:A),"$#,##0.00")TEXT(AVERAGE(A:A),
22.22.10.Uses the NOW and TEXT function to format the date and time.Uses the NOW and TEXT function to format the date and time.
22.22.11.Display text such as Today is Friday, September 14, 2007.Display text such as Today is Friday, September 14, 2007.