Changing Windows Regional Settings and the Office UI Language

Throughout this chapter, the potential errors will be demonstrated by using the three locales outlined in the following table.

Setting

U.S.

UK

Norway

Decimal Separator . . ,

Thousand Separator , , .

Date Order

mm/dd/yyyy

dd/mm/yyyy

dd.mm.yyyy

Date Separator

/

/

Example Number: 1234.56

1,234.56

1,234.56

1.234,56

Example Date: February 10, 2007

02/10/2007

10/02/2007

10.02.2007

Windows and Excel Language

English

English

Norwegian

Text for Boolean True

True

True

Sann

The regional settings are changed using the Regional Settings applet (Regional Options in Windows 2000) in Windows Control Panel, and the Office 2007 language is changed using the Microsoft Office 2007 Language Settings program. Unfortunately, the only way to change the Windows language is to install a new version from scratch.

When testing your application, it is a very good idea to use some fictional regional settings, such as having a hash mark (#) for the thousands separator, an exclamation point (!) for the decimal separator, and a year/month/day date order. It is then very easy to determine if your application is using your settings or some internal default. For completeness, you should also have a machine in your office with a different language version of Windows from the one you normally use.

+1 0

Responses

  • romolo
    How to change regional settings via vba?
    7 years ago

Post a comment