General Number
Displays a number without thousand separators.
Currency
Displays thousand separators as well as two decimal places.
Fixed
Displays at least one digit to the left of the decimal place and two digits to the right of the decimal place.
Standard
Displays the thousand separators, at least one digit to the left of the decimal place, and two digits to the right of the decimal place.
Percent
Displays a percent value – that is, a number multiplied by 100 with a percent sign. Displays two digits to the right of the decimal place.
Scientific
Scientific notation.
Yes/No
Displays No if the number is 0. Displays Yes if the number is not 0.
True/False
Displays False if the number is 0. Displays True if the number is not 0.
On/Off
Displays Off if the number is 0. Displays On is the number is not 0.
General Date
Displays date based on your system settings
Long Date
Displays date based on your system’s long date setting
Medium Date
Displays date based on your system’s medium date setting
Short Date
Displays date based on your system’s short date setting
Long Time
Displays time based on your system’s long time setting
Medium Time
Displays time based on your system’s medium time setting
Short Time
Displays time based on your system’s short time setting