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.