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.
GCPS Tech Tips
Microsoft 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.
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...
Excel turns what you have typed
into the day’s date.
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.
To set the number format for a row, you select that row by clicking the number of that row.
Then, with your cursor somewhere in the highlighted section,
… click your right mouse button.
That will drop down a box of things you can do with those highlighted cells. Click on “Format 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.
Clicking on the “Date” category will open a list of ways Excel can display the date for you.
Choose the one you like, click on it,
and thereafter, any “number-slash-number” you enter in that row Excel will display as the date.
To set the date format for all the cells in a column, start by selecting a whole column.
Then, after right clicking in the highlighted area, go to...
“Format Cells”... “Date”... “Type”... and “OK.”
You can even select a whole worksheet
and set it to show any “number-slash-number”
you enter as the date.
what happens when you intend to enter
a fraction into a cell?
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.
Once again, select the cell, row, column, or whole worksheet you want to format...
Right click in the highlighted area
and click on “Format Cells”...
That opens the formatting box.
Look down the list to find “Fraction.”
When you click on “Fraction,”
Excel will give you a list of ways
to display fractions.
Select the one you want and click “OK.”
Thereafter, Excel will show fractions
as you enter them.
You can show
the numbers you
Or format them as “Zip Codes,” “Phone Numbers,” or “Social Security Numbers.”
You can show the “Time”
in many different formats.
Or you can select “Text” to display things
exactly as you type them in.
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!
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
Gwinnett County Public Schools | 437 Old Peachtree Road NW | Suwanee | GA | 30024-2978 | 678-301-6000