Format Predefined Number

Description       The following predefined number formats may be used with the Format function. Predefined formats may not be combined with user defined formats or other predefined formats.

Form                  Description

General Number
Return number as is.

Currency             Same as user defined number format "$#,##0.00;($#,##0.00)"
Not locale dependent at this time.

Fixed                   Same as user defined number format "0.00".

Standard             Same as user defined number format "#,##0.00".

Percent                Same as user defined number format "0.00%".

Scientific             Same as user defined number format "0.00E+00".

Yes/No                Return "No" if zero, else return "Yes".

True/False           Return "True" if zero, else return "False".

On/Off                 Return "On" if zero, else return "Off".

Example            '#Language "WWB-COM"
Sub Main
    Debug.Print Format$(2.145,"Standard") ' 2.15
EndSub