XL: How to Display the Current Date and Time with Text (214093)
The information in this article applies to:
- Microsoft Excel 2000
- Microsoft Excel 2002
- Microsoft Excel 97 for Windows
- Microsoft Excel 2001 for Mac
- Microsoft Excel 98 Macintosh Edition
This article was previously published under Q214093 SUMMARY
You can enter the current date and time as text by using the TEXT
function with the TODAY or NOW functions. For example, to display
where 2/18/98 is the current date, use the following formula:
="Today is "TEXT(TODAY(),"m/d/yy")
NOTE: You can substitute the NOW function for the TODAY function in the preceding formula to display the date and time or just the time (depending on the number format that you specify).
You can also display
and preserve the value of the date as a serial number rather than
converting it to text.
To display the current time, use the following formula:
This formula updates each time the sheet is calculated.
Modification Type: | Major | Last Reviewed: | 5/28/2003 |
---|
Keywords: | kbdta kbhowto KB214093 |
---|
|