LocVal

 

Purpose:

Interprets the string as a number and returns its value (while respecting any localized decimal or 1000 separators).

Parameter:

String          Number (as string)

String         (optional) Country code/ISO Code of country, whose format is to be used. Format: <ISO639>-<ISO3166> e.g. de-de or en-us.

http://msdn.microsoft.com/en-us/library/0h88fahh%28VS.85%29.aspx

Return value:

Number

Example:

LocVal ("12","de-de")  Result: 12,00

LocVal ("12,00","en-us")       Result:1200,00