Syntax

Example

Description/Remarks

FORMAT value, format_string

FORMAT NOW, " yyyymmddtttt"

If [A1] = 0.251, then

FORMAT [A1], "0.00%"

returns 25.10%

SVAR 1 = FORMAT (DATE_INCR NOW, -86400), "Short Date"

Svar 1 contains yesterday's date.

Returns a string value in user-controlled format.

Value may be a string or a number.  

Note:  If the value is a string containing a number or a date/time stamp to which numeric or date/time formatting will be applied, it must be correctly formatted for the regional options on your computer.  To convert a numeric string to match your regional options, use the LOCAL_S command.

For valid options for the format_string parameter, see instructions on user-controlled formats for dates, numbers and strings.