Enter Numbers

  • 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.


890 total views, 2 views today

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>