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

Sub Main

    Debug.Print Format$(2.145,"Standard") ' 2.15

End Sub