ProAdmin supports the following Windows’ Regional and Language Options (found in the Control Panel). Since ProAdmin directly refers to the Windows settings, there is no need to explicitly modify any settings within ProAdmin.

• The Decimal symbol and Digit grouping symbol determine how numbers are formatted outside ProAdmin. For example, the default English (United States) setting uses the period (.) as a decimal symbol and a comma (,) to group digits (e.g., “1,234.56”), while the German (Germany) default setting does just the opposite (e.g., “1.234,56”). ProAdmin uses these symbols to handle numbers in a few limited circumstances:

• When copying and pasting data between ProAdmin spreadsheets and other applications such as Excel;

• When importing census data from delimited text files (*.csv) or fixed width files;

For example, you can use Excel to open .csv files created with ProAdmin or to use ProAdmin to import .csv and fixed width files created with Excel, regardless of how your Regional and Language Options are set – as long as the same Regional and Language Options were in place when the file was created and opened. If you share files with users in other countries, Excel files are preferred over text files because they contain values, rather than formatted text strings, and thus they will avoid any issues with differing settings.

Although the Regional decimal symbol and digit grouping symbol are used in the situations above, numbers inside ProAdmin are always displayed using the period (.) as the decimal symbol and the comma (,) as the digit grouping symbol. Exception: The Spreadsheet Edit command displays numeric fields according to your Regional and Language Options.

• The List separator determines the symbol that appears between values on the same line in a delimited text file (*.csv). For example, the list separator might be a comma (,) or a semicolon (;). ProAdmin uses the list separator when saving output to delimited text files (*.csv).

• The Short date format determines the order of days, months and years in a date constant. For example, under the English (United States) setting, dates are specified in month/day/year order, but under the French (Canada) setting, dates are specified in year/month/day order. ProAdmin uses the short date format when displaying and entering dates. This includes dates found in expressions, such as Benefit Formulas and Selection Expressions.

Note that ProAdmin always uses the “forward slash” as the date separator symbol (/) for display purposes, regardless of the Regional and Language Options.