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.

Was this article helpful?

+1 0
The Accidental Blogging Millionaires

The Accidental Blogging Millionaires

Get Inspired By The Most Popular Bloggers Online! If You Want To Skyrocket Your Success With Business And Improve Your Overall Life You Need To Have A Look At The Accidental Blogging Millionaires! Business can be a fight, particularly when you’re trying to establish one online and like all fights, to succeed you must find the winning techniques and apply them.

Get My Free Ebook


Responses

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

Post a comment