Num - script and chart function

This script function formats 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 number format set in the operating system is used.

Syntax:  

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

 

Examples and results:

The examples below assume the following operating system settings:

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

Example	Results	Setting 1	Setting 2
Num( A, '0.0' ) where A=35648.375	String:	35 648 375	35648.375
	Number:	35648375	35648.375
Num( A, '#,##0.##', '.' , ',' ) where A=35648	String:	35,648.00	35,648.00
	Number:	35648	35648
Num( pi( ), '0,00' )	String:	3,14	003
	Number:	3.141592653	3.141592653