Number Format « Date Functions « VBA / Excel / Access / Word






  1. VBA / Excel / Access / Word
  2. Date Functions
  3. Number Format
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.Format(dblNumber "###,##0.00"): double
14.Characters for Creating Your Own Number Formats
15.returns a currency formatted with four decimal places: