Date, Time, Currency Formats Different from International

 Country              International                     Visual Basic
                      displays                          displays
 --------------------------------------------------------------------

 Austria              Short Date:  1994-5-6             1994-5-Friday

 Canada (French)      Short Date:  94/5/6               94-5-6

 Hungary              Long Date:   1994. May 6          1994 May 6.
                      Short Date:  1994.5.6             1994.5.6.
				

CAUSE

Austria

This incorrect date format is caused by a problem in Microsoft Windows. When you set the Country setting to Austria in the International dialog box, the [intl] section of the WIN.INI file has the following incorrect setting: This causes the date in Visual Basic modules to be formatted with the full day name.

Canada(French)

This incorrect date format is caused by a problem in Microsoft Windows. The [intl] section in the WIN.INI file has the following inconsistent settings: The date separators in these settings should be consistent. (The default should be the hyphen (-) character.)

Hungary

This incorrect date format is also caused by a problem in Microsoft Windows. In the [intl] section in the WIN.INI file, both the sShortDate and the sLongDate settings correctly show a period at the end. The Visual Basic module uses these correct settings to format a date. In this case, the format of the dates in the International dialog box are incorrect.

Croatia, Romania, Serbia, and Slovenia

Visual Basic, Applications Edition does not recognize the Croatia, Romania, Serbia, and Slovenia system locales. For languages that are not recognized, date, time, currency, and number formats in Visual Basic modules use the default United States/English International settings.

More information about this is available in the XLREADME.HLP file. To view this file, do the following:

1. In Microsoft Excel, press F1 to run Help.
2. From the File menu, choose Open. From the File Name list, select XLREADME.HLP and choose OK.
3. Select the Microsoft Excel Product Update topic.
4. Scroll down to the Unrecognized System Locales topic.