Format(dblNumber "###,##0.00"): double : Number Format « Date Functions « VBA / Excel / Access / Word

Home
VBA / Excel / Access / Word
1.Access
2.Application
3.Data Type
4.Data Type Functions
5.Date Functions
6.Excel
7.File Path
8.Forms
9.Language Basics
10.Math Functions
11.Outlook
12.PowerPoint
13.String Functions
14.Windows API
15.Word
16.XML
VBA / Excel / Access / Word » Date Functions » Number Format 




Format(dblNumber "###,##0.00"): double
 
Sub numFormat()
    dblNumber = 12345.678
    Debug.Print dblNumber
    Debug.Print Format(dblNumber "###,##0.00")

End Sub

 
Related examples in the same category
1.General Number - The number is displayed with no thousand separator.
2.Currency - The number is displayed with two decimal places, a thousand separator, and the currency symbol appropriate to the system locale.
3.Fixed - The number is displayed with two decimal places and at least one integer place.
4.Standard - The number is displayed with two decimal places, at least one integer place, and a thousand separator (when needed).
5.Percent - The number is displayed multiplied by 100, with two decimal places, and with a percent sign.
6.Scientific - The number is displayed in scientific notation.
7.Yes/No - A non-zero number is displayed as Yes; a zero number is displayed as No.
8.True/False - A non-zero number is displayed as True; a zero number is displayed as False.
9.On/Off - A non-zero number is displayed as On; a zero number is displayed as Off.
10.Format(dblNumber "0.00")
11.Format(dblNumber "000000.00")
12.Format(dblNumber "#####0")
13.Characters for Creating Your Own Number Formats
14.returns a currency formatted with four decimal places:
java2s.com  | Contact Us | Privacy Policy
Copyright 2009 - 12 Demo Source and Support. All rights reserved.
All other trademarks are property of their respective owners.