Num# - 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:  

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

 

Examples and results:

The examples below assume the two following operating system settings:

	Default setting 1	Default setting 2
Number format	# ##0,#	#,##0.#

Example	Results	Setting 1	Setting 2
Num#( A, '#' ) where A=35,648.375	String:	35,648.375	35648.375
	Number:	-	35648.375
Num#( A, '#.#', '.' , ',') where A=35,648.375	String:	35,648.375	35,648.375
	Number:	35648.375	35648.375
Num#( A, '#.#',',','.' ) where A=35648.375	String:	35648.375	35648.375
	Number:	35648375	35648375
Num#( A, 'abc#,#' ) where A=abc123,4	String:	abc123,4	abc123,4
	Number:	123.4	1234