Currency and Phone Field Format Strings
The table below lists the format string options for currency and phone number fields.
| Field Type | Option | Description |
|---|---|---|
| Currency | m | Money. The format of the field must be a floating-point value. The value is converted to a string that represents a currency amount. |
| Phone Number | # | Use the # sign to indicate how you want a number to display. You can use any character as a separator except letters and numbers. The default phone number format is (###) ###-####. |
Note: A format string must begin with a % sign and end with a
format type character:
[%] [type]