Format Specifier Syntax

For functions that produce a string as an output, such as Format Into String and Array To Spreadsheet String, a format specifier uses the following syntax elements. Double brackets ( [] ) enclose optional elements.

%[][+][^][0][Width][.Precision][{unit}]Conversion Code

For functions that scan a string, such as Scan From String and Spreadsheet String to Array, a format specifier uses the following simplified syntax elements.

%[Width]Conversion Code

The Format Into String, Format Into File, Scan From String, and Scan From File functions can use multiple format specifiers in the format string parameter, one for each input or output to the resizable function.

You use format specifiers to format strings, convert a number into a string, and insert non-displayable characters in strings. Refer to the examples of format specifiers for more information.