XL98: Format Function May Return an Incorrect Date (182244)
The information in this article applies to:
- Microsoft Excel 98 Macintosh Edition
This article was previously published under Q182244 SYMPTOMS
In Microsoft Excel 98, if you run a Visual Basic for Applications macro
that uses the Format function with a date, you may notice the following
problems:
- When you use the General Date format or the Short Date format, the
month, day, and/or year of the dates may be switched.
For example, although the date January 10, 1998 may appear in the cell
as 1/10/98, the actual value of the date is October 1, 1998 (10/1/98).
- When you use the General Date format or the Short Date format, some of
the dates appear as text, not as valid dates.
This problem may occur if the day or year of a date is greater than 12.
For example, the date July 30, 1998 may appear in the cell as the text
string "30/07/98" instead of the date 30/07/98.
CAUSE
These problems may occur if you are using regional settings that use a date
order of either day-month-year or year-month-day.
STATUS
Microsoft has confirmed this to be a problem in Microsoft Excel 98
Macintosh Edition.
Modification Type: | Major | Last Reviewed: | 9/11/2002 |
---|
Keywords: | kbdtacode kbprb KB182244 |
---|
|