Converts a string, number or currency to their numeric representation.
The number interpretation pattern depends on the server locale (see the following sample).
ToNumber( "2,5" ) returns on English server: 25 returns on German server: 2.5
ToNumber( x )
x | string, number or currency to convert to a number |
---|
The numeric value of the string.
ToNumber("123.42") -> Returns 123.42.
ToNumber("$123.42") -> Returns 123.42.
ToNumber(123.42) -> Returns 123.42.