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 )	 

The numeric value of the string.

ToNumber("123.42")
-> Returns 123.42.

ToNumber("$123.42")
-> Returns 123.42.

ToNumber(123.42)
-> Returns 123.42.

• CDbl function
• ToText function
• ToWords function