- To enter the sales amounts in particular column, you would type the dollar sign ($), followed by the amount. For other currency then dollar, Go to Home tab, In Number tab click on currency symbol. Click on required Currency.
- 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, 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.
If you want to know how to add, divide, multiply, and subtract numbers in Excel by using formulas, then,Click here.
861 total views, 2 views today