Microsoft KB Archive/170739

= XL97: Date Format Is Not Retained in Parameters Dialog Box =

Article ID: 170739

Article Last Modified on 4/21/2001

-

APPLIES TO


 * Microsoft Excel 97 Standard Edition

-



This article was previously published under Q170739



SYMPTOMS
When you click Parameters on the Get External Data menu, the date parameter in the "Use the following value" box of the Parameters dialog box is not formatted as a date. Instead the parameter is displayed as a value.



CAUSE
This behavior occurs when you do the following:


 * You use the Get External Data command and a date in a parameter query. -and-


 * In the Enter Parameter Value dialog box, you click "Use this value/reference for future refreshes."



STATUS
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. This problem no longer occurs in Microsoft Excel 2000.



MORE INFORMATION
When you use the Get External Data command, you can specify a criterion that uses a parameter query. A parameter query prompts you for an input to use in the criteria for the query. However, if the parameter query uses a date, when you store the date in the parameter by clicking the "Use this value/reference for future refreshes," the date is not displayed in a date format in the Parameters dialog box. Instead, the date is displayed as the date serial value. For example, if you enter the date June 24, 1997 in a parameter query, the date is stored in the parameter and is displayed in the Parameters dialog box as 35605.

