Characters for Creating Your Own Number Formats : Number Format « Date Functions « VBA / Excel / Access / Word






  1. VBA / Excel / Access / Word
  2. Date Functions
  3. Number Format

Characters for Creating Your Own Number Formats

 
        
Character      Explanation         
[None]         Displays the number without any formatting.         
0              Placeholder for a digit.         
#              Placeholder for a digit. If there's no digit, VBA displays nothing.        
.              Placeholder for a decimal.         
%              Placeholder for a percent character. 
,              Thousand separator (depending on locale, a comma or a period).        
:              Time separator.        
/              Date separator. 
E- E+ e- e+    Scientific format: E- or e- places a minus sign next to negative exponents. E+ or e+ places a minus sign next to negative exponents and places a plus sign next to positive exponents.        
- + $ ()       Displays a literal character.        
\[character]   Displays the literal character.        
"[string]"     Displays the literal character.








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.Format(dblNumber "###,##0.00"): double
14.returns a currency formatted with four decimal places: