you can read these about format
or try yourself in the number tab
make a listbox with some values (eg mine is =valuelist(7, 0.7) ), change format and apply to see the result in listbox and format in format pattern
here's an explanation from the QV help file:
- To denote a specific number of digits, use the symbol "0" for each digit.
- To denote a possible digit, use the symbol "#". If the format contains only #'s to the left of the decimal point, numbers less than 1 begin with a decimal point.
- To mark the position of the thousands separator or the decimal separator, use the thousands separator and the decimal separator.
hope this helps