XL: Incorrect Date Format with Canadian English

 Last reviewed: August 23, 1996
Article ID: Q86636
The information in this article applies to:
  • Microsoft Excel for Windows, versions 4.0, 5.0, 5.0c
  • Microsoft Excel for Windows 95, version 7.0

SUMMARY

The date number format is listed incorrectly in Microsoft Excel when the Country is configured for "Canada [English]" in Windows version 3.x or "English (Canadian)" in Windows 95 and Windows NT. The format displays as jj/mm/aa instead of dd/mm/yy.

STATUS

Microsoft has confirmed this to be a problem in the versions of Microsoft Excel listed above.

MORE INFORMATION

Steps to Reproduce Problem

Windows 3.x and Microsoft Excel 4.0

1. Open the Control Panel. 2. Choose the International icon. 3. Choose Country and change it to Canada [English] and choose OK. 4. Open Microsoft Excel. 5. From the Format menu, choose Number. 6. Select Date from the Category list.

Windows 95 and Microsoft Excel 7.0

1. On the Start menu, point to Settings and then click Control Panel. 2. Double-click the Regional Settings icon. 3. In the list of countries, select "English (Canadian)". Click OK. If 
   prompted to restart Windows, click No.
4. In Microsoft Excel, click Cells on the Format menu. 5. Select the Number tab. 6. In the list of categories, click "Custom". 7. Scroll down in the list of format Types.

The incorrect date format will be displayed (jj/mm/aa).

KBCategory: kbusage kbprb
KBSubcategory:

Additional reference words: 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: August 23, 1996
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.