Tuesday, 11 August 2009
Still on Excel 2007: Other numbers and how to enter them..
Fractions:
To enter fractions leave space between the whole number and the fraction, e.g 1 space 1/8.
To enter a fraction only, enter zero first, ie 01/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.
The next topic will be about QUICK WAYS TO ENTER, EDIT DATA AND REVISE WORKSHEETS.
The next topic will be about QUICK WAYS TO ENTER, EDIT DATA AND REVISE WORKSHEETS.
0 comments:
Post a Comment