Decimal and digit grouping symbols in numbers
Any number you enter directly into a template formula must use a period (.) as the decimal symbol and must not contain any digit grouping symbol.
For example, to multiply a cell's value by one and three-tenths, the template formula must be written as
[F1] * 1.3
To multiple a cell's value by one hundred and thirty-seven thousand, two hundred and fifty six, the template formula must be written as
[F1] * 137256
Valid date/time stamps
Valid formats for months include numerals (2), the full name of the month (February, febbraio, etc.), or the Windows abbreviation for the name of the month (Feb). Uppercase or lowercase letters can be used in the name of the month.
The year can be expressed with two digits (00) or with four digits (2000).
There must be a non-numeric character, such as a space, between the date and the time.
Valid time stamps can be expressed in 12-hour time (such as 1:30 PM) or 24-hour time (such as 13:30). If the decimal symbol for your regional options is used to separate the hour, minute, and/or second, you must use the REPLACE command to substitute a different time separator.
Commas (,) separate parameters in a command
Just as they are documented in the Template Commands Reference chapter of the Online User Guide, template parameters must be separated by a comma.
For example, to cause the template to take one action if the operator accepts the entered data but take a different action if the operator notices an error, the template formula must be written as
IF DATAOK , SAVEROW , GOTO [F1]
Colons (:) separate commands in a formula
Just as documented in the Multiple commands in one cell section of the Online User Guide, consecutive commands in the formula of one cell must be separated by a colon.
For example, to perform the SAVEROW and GOTO [C1] commands in the formula of one template cell, that formula must be written as:
SAVEROW : GOTO [C1]
More: