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