06-14-2007 04:07 AM
06-14-2007 05:06 AM
%[$][-][+][#][^][0][Width][.Precision || _SignificantDigits][{Unit}][<Embedded information>]Conversion Code
where Width must be a number greater than zero and .Precision and _SignificantDigits must be a number greater than or equal to zero.
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
06-14-2007 05:08 AM
06-14-2007 05:12 AM
The number after the Decimal point in the format specifier points to the No of digits of precision required in the display. I dont know about the value preceeding the decimal in the Format Specifier field. It seems not to take any effect on the left side of the decimal point.
See the Help for more details on the various Format Specifiers.
See the attached screenshot.
06-14-2007 08:49 AM
06-14-2007 09:40 AM
Remember that in, for example, %6.7f the 6 represents the MINIMUM field width. The width will be expanded if necessary. In this case expansion of the width is needed as the result has a decimal point with 7 digits after it and at least 1 before, so %9.7f would give the same result.
In 8.20 (and possibly earlier revs) you can place a 'format into string', and double click on it to get a dialogue.