Money# - script and chart function

This function evaluates the expression numerically according to the string given as format-code. Decimal separator and thousands separator can be set as third and fourth parameters. If the parameters 2-4 are omitted, the default number format set by script variables or in the operating system is used.

Syntax:  

Money#(expression [ , format-code [ , decimal-sep [ , thousands-sep ] ] ])

 

The money# function generally behaves just like the num# function but takes its default values for decimal and thousand separator from the script variables for money format or the system settings for currency.

Examples and results:

The examples below assume the two following operating system settings:

	Default setting 1	Default setting 2
Money format	kr # ##0,00	$ #,##0.00

Example	Results	Setting 1	Setting 2
Money#( , '# ##0,00 kr' ) where A=35 648,37 kr	String:	35 648.37 kr	35 648.37 kr
	Number:	35648.37	3564837
Money#( A, ' $#', '.', ',' ) where A= $35,648.37	String:	$35,648.37	$35,648.37
	Number:	35648.37	35648.37