next up previous contents index
Next: FRAC Up: A. Function Reference Previous: FORECAST   Contents   Index


FORMAT

Syntax: FORMAT(F, N, X)

F = the SpreadScript format code
N = the precision level, from 0 to 15
X = a numeric value

FORMAT returns the string formed by formatting the numeric value X using the SpreadScript format code F and the precision specified by N. For a list of valid formats see Tables 3.2 and 3.3.

Examples:

FORMAT(``dollars'', 2, 660406) = ``$660,406.00''

FORMAT(``hex'', 0, 660406) = ``OxA13B6''

FORMAT(``general'', 2, 660406) = ``6.6e+05''

Excel function: N/A


next up previous contents index
Next: FRAC Up: A. Function Reference Previous: FORECAST   Contents   Index
SpreadScript User's Guide, Version 1.2
Grey Trout Software
02 March 2003