| Text Formats | ||
|---|---|---|
| < | Forces text to lower case. |
Type: Leash, Extra Long Display: leash, extra long |
| > | Forces text to upper case. |
Type: ca Display: CA |
| @ | Requires character entry or space. | Example: Use for a text field that must always have the same number of characters (like a social security number) @@@-@@-@@@@. |
| @;none | Controls what value is shown | Displays value entered; if no value entered, displays "none." |
| Number/Currency Formats | |
|---|---|
| General Number | Displays the number as entered. Example: 24000 |
| Currency | Uses the currency format specified in your Windows Regional Settings, including the comma separator and currency symbol. Example: $24,000.00 |
| Euro | Uses the standard currency format with the Euro symbol. Example: €24,000.00 |
| Fixed | Uses the number format specified in your Windows Regional Settings. Displays at least one digit. Example: 24000.00 |
| Standard | Uses the number format specified in your Windows Regional Settings, including the comma thousands separator. Example: 24,000.00 |
| Percent | Multiplies the value by 100 and adds % symbol. Enter: .03 Displays 3% |
| Scientific | Converts the number to scientific notation. Example: 24E+3 |