Format Property — Number and Currency Data Types Example
The following are examples of the predefined number formats.
| Setting | Data | Display |
|---|---|---|
| General Number | 3456.789 –3456.789 $213.21 |
3456.789 –3456.789 $213.21 |
| Currency | 3456.789 –3456.789 |
$3,456.79 ($3,456.79) |
| Fixed | 3456.789 –3456.789 3.56645 |
3456.79 –3456.79 3.57 |
| Standard | 3456.789 | 3,456.79 |
| Percent | 3 0.45 |
300% 45% |
| Scientific | 3456.789 –3456.789 |
3.46E+03 –3.46E+03 |
The following are examples of custom number formats.
| Setting | Description |
|---|---|
| 0;(0);;"Null" | Display positive values normally; display negative values in parentheses; display the word "Null" if the value is Null. |
| +0.0;–0.0;0.0 | Display a plus (+) or minus (–) sign with positive or negative numbers; display 0.0 if the value is zero. |