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:

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