Notational Conventions (Numbers, Formulas, Dates)

1. Overview

All examples of numbers, formulas, dates, and lists in this Help file use the International/English language settings:

Decimal point: .
Thousand separator: ,
List (formula parameter) separator: ,

2. Example Using English Notation

Formulas and numbers must be entered as, for example:

=SUM(5589.7, 56.55, field1)

3. Adapting to Your Windows Language Settings

If your Windows language settings use different separators, you must adapt the notation accordingly. For example, if your settings use:

Decimal point: ,
Thousand separator: [space]
List separator: ;

then the formula becomes:

=SUM(5589,7; 56,55; field1)

4. Locale Settings in GS-Calc

By default, GS-Calc uses the current user's Windows Language/International Settings.

You can override this by selecting:

Settings > Locales > Generic (Fixed)

This forces GS-Calc to use International/English notation regardless of the Windows language version.