This slide illustrates another difference between display and underlying data. The sale price at E2 is displayed as $103,000 while the underlying data is 103000.
Other numbers and how to enter them
- To enter fractions, leave a space between the whole number and the fraction. For example, 1 1/8.
- To enter a fraction only, enter a zero first. For example, 0 1/4. If you enter 1/4 without the zero, Excel will interpret the number as a date, January 4.
- If you type (100) to indicate a negative number by parentheses, Excel will display the number as -100.