dec PowerHome formula function
Description
Converts a string to a decimal number using the currently defined region settings.
Syntax
dec ( s )
| Argument |
Description |
|
s
|
A string whose value you want returned as a decimal value.
|
Return value
Decimal. Returns the value of the string as a decimal. If the string is not a valid number or if it contains an incompatible datatype, Dec returns 0.
Usage
The dec function is region aware. This function will work with the string representation of a number using the current region settings specified within the OS. This function is very useful for regions where the period character is used as the thousands separator and the comma character is used as a decimal point. Without this function, PowerHome interprets numbers using the standard region settings for the United States.