1 / 30

A few tricks to take you beyond the basics of Microsoft Office 2010

A few tricks to take you beyond the basics of Microsoft Office 2010. GCPS Tech Tips. Microsoft Excel 2010 : Formatting numbers in cells. Excel 2010 : Formatting Numbers in Cells.

salaam
Download Presentation

A few tricks to take you beyond the basics of Microsoft Office 2010

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. A few tricks to take you beyond the basics of Microsoft Office 2010 GCPS Tech Tips Microsoft Excel 2010 : Formatting numbers in cells.

  2. Excel 2010 : Formatting Numbers in Cells Gwinnett County Public Schools is committed to providing information related to student technology use in a manner that is clear, concise, organized, accessible, and current. To that end, GCPS has provided articles and handouts on its web site. The following resource is provided for information only and is NOT an official policy or procedure of Gwinnett County Public Schools. This resource may be used by schools and the school communities to share information and ideas around student technology use. Should a conflict between the information on this site and the existing policy, regulation or rule occur, then the official or approved policy, rule or regulation supersedes the resources in this document.

  3. Excel 2010 : Formatting Numbers in Cells One of the neatest things that Excel does for you is enter the day’s date with minimal prompting. For example, if it is March 14th and you want that date in a certain cell, you only have to type “3/14” in that cell. As soon as you press the “Tab” key to move to the next cell...

  4. Excel 2010 : Formatting Numbers in Cells Excel turns what you have typed into the day’s date.

  5. Excel 2010 : Formatting Numbers in Cells In fact, you can choose from over 15 ways of writing the day’s date... and you can set any row, any column, even a whole worksheet to use the number form you like best.

  6. Excel 2010 : Formatting Numbers in Cells To set the number format for a row, you select that row by clicking the number of that row.

  7. Excel 2010 : Formatting Numbers in Cells Then, with your cursor somewhere in the highlighted section, … click your right mouse button.

  8. Excel 2010 : Formatting Numbers in Cells That will drop down a box of things you can do with those highlighted cells. Click on “Format Cells...”

  9. Excel 2010 : Formatting Numbers in Cells That brings up a box where you can “Format Cells.” You will see a list of things you can format within a cell, a row, a column, or even the whole worksheet.

  10. Excel 2010 : Formatting Numbers in Cells Clicking on the “Date” category will open a list of ways Excel can display the date for you.

  11. Excel 2010 : Formatting Numbers in Cells Choose the one you like, click on it,

  12. Excel 2010 : Formatting Numbers in Cells click “OK”

  13. Excel 2010 : Formatting Numbers in Cells and thereafter, any “number-slash-number” you enter in that row Excel will display as the date.

  14. Excel 2010 : Formatting Numbers in Cells To set the date format for all the cells in a column, start by selecting a whole column.

  15. Excel 2010 : Formatting Numbers in Cells Then, after right clicking in the highlighted area, go to... “Format Cells”... “Date”... “Type”... and “OK.”

  16. Excel 2010 : Formatting Numbers in Cells You can even select a whole worksheet and set it to show any “number-slash-number” you enter as the date.

  17. Excel 2010 : Formatting Numbers in Cells But... what happens when you intend to enter a fraction into a cell?

  18. Excel 2010 : Formatting Numbers in Cells Excel doesn’t know any better than to turn it into a date. You need to re-format the way Excel shows numbers in that cell.

  19. Excel 2010 : Formatting Numbers in Cells Once again, select the cell, row, column, or whole worksheet you want to format...

  20. Excel 2010 : Formatting Numbers in Cells Right click in the highlighted area and click on “Format Cells”...

  21. Excel 2010 : Formatting Numbers in Cells That opens the formatting box. Look down the list to find “Fraction.”

  22. Excel 2010 : Formatting Numbers in Cells When you click on “Fraction,” Excel will give you a list of ways to display fractions.

  23. Excel 2010 : Formatting Numbers in Cells Select the one you want and click “OK.”

  24. Excel 2010 : Formatting Numbers in Cells Thereafter, Excel will show fractions as you enter them.

  25. Excel 2010 : Formatting Numbers in Cells You can show the numbers you enter as “Percentages”

  26. Excel 2010 : Formatting Numbers in Cells Or format them as “Zip Codes,” “Phone Numbers,” or “Social Security Numbers.”

  27. Excel 2010 : Formatting Numbers in Cells You can show the “Time” in many different formats.

  28. Excel 2010 : Formatting Numbers in Cells Or you can select “Text” to display things exactly as you type them in.

  29. Excel 2010 : Formatting Numbers in Cells That’s all there is to it. Now, if you would like a copy of the step-by-step directions for formatting numbers in cells with Excel 2010, just print this last page. Have fun formatting!

  30. GCPS Tech Tips We hope you found this technology tip useful. Feel free to share this tip with colleagues and students. More technology tips can be found on the IMD website here. For questions or comments about the technology tips, send email to IMD_Connection_Newsletter@gwinnett.k12.ga.us Gwinnett County Public Schools | 437 Old Peachtree Road NW | Suwanee | GA | 30024-2978 | 678-301-6000

More Related