Dates in Pivot Table May Be Converted into Text (109420)
The information in this article applies to:
- Microsoft Excel for Windows 95
- Microsoft Excel for Windows 5.0c
- Microsoft Excel for the Macintosh 5.0a
- Microsoft Excel for Windows NT 5.0
This article was previously published under Q109420 SUMMARY
In the versions of Microsoft Excel listed in the beginning of this article,
when you create a PivotTable that uses dates as row or column fields, the
dates are converted to text. Because of this conversion, you may have
difficulty sorting or otherwise manipulating these dates.
NOTE: This behavior may also occur when you use time values or data
formatted with the Zip Code format (in Microsoft Excel version 7.0) as row
or column fields. In this case, with data formatted with the Zip Code
format in Microsoft Excel version 7.0, any leading zeros in the zip codes
will be lost.
REFERENCES
"User's Guide," version 5.0, pages 470-474
Modification Type: | Minor | Last Reviewed: | 8/15/2005 |
---|
Keywords: | kbprb KB109420 |
---|
|