Microsoft KB Archive/47974

{| = Using System Date as Default in an INPUT Function in Excel =
 * width="100%"|

Last reviewed: October 31, 1994

Article ID: Q47974 The information in this article applies to:
 * Microsoft Excel for Windows, versions 2.x, 3.0, 4.0
 * Microsoft Excel for OS/2, versions 2.2, 3.0

SUMMARY
The following is an example of an INPUT function that uses the computer's system date as the default value. You can type over the default or choose OK to accept the system date.

=INPUT(&quot;Prompt text&quot;,2,&quot;Title text&quot;,TEXT(NOW,&quot;mm/dd/yy&quot;)) The TEXT function specifies the desired formatting of the serial number. The data type may be either 1 (number) or 2 (text).
 * }