Excel: Dates Formatted with mmm Display Incorrectly

Last reviewed: November 29, 1994
Article ID: Q74400
The information in this article applies to:
  • Microsoft Excel for the Macintosh, versions 2.2, 3.0, 4.0

SUMMARY

Microsoft Excel uses information from the itl1 resource of the System file to display abbreviated date formats. If the itl1 resource has been modified to display more than three letters for an abbreviated date, Excel will use that many letters to display the name of the month when a cell has a number format "mmm".

MORE INFORMATION

As a result, the date CDEV (control panel device) shipped with TMaker's WriteNow, which modifies the itl1 System resource even after the CDEV has been removed from the System, may cause Excel's abbreviated dates to display incorrectly. To reset the System resource, you must either use the same CDEV to change the date abbreviations back, or use some resource editor to specify that the number of characters used to abbreviate a month in the itl1 resource is three.


KBCategory: kbusage
KBSubcategory:

Additional reference words: 2.2 2.20 3.0 3.00 4.0 4.00


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: November 29, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.