Hampden-Sydney College | Academic Computing
Tuesday, December 02, 2008
  TECHNOLOGY
 
  Blackboard
  Blackboard Help
  Faculty Awards
  Software Downloads
  Software Tutorials
  Teaching Links
  Technology Lunch Table

  H-SC HOME
 
  Academics
  Admissions
  Alumni
  Athletics
  Blackboard
  Bookstore
  Calendar
  Commencement
  Computing Center
  E-mail Online
  Financial Aid
  Fitness
  Instr Technology
  Leadership Center
  Library
  Making A Gift
  News
  Parents
  Paying for College
  Search
  Site Index
  Student Life
  Visiting HSC

  CONTACT US
 
  Students
  Faculty & Staff
  Faculty Profiles
  Staff Profiles
  Job Openings

 
   INSTRUCTIONAL TECHNOLOGY

MORE CELL FORMATTING

We want our numbers to look better. To do this we'll include dollar signs and decimal points in our numbers. This is done by using the mouse. Point to cell C6, hold down the left mouse button and drag down slowly to high light cells C6 through C19. Your screen should look like the one below.

 

 

 

 

 

 

Now point anywhere in the highlighted area and click the right mouse button. A pop-up menu will appear. Click-on Format Cells.

 

 

 

 

 

 

 

 

 

 

 

 

Click-on the Number (this is what you want) "Tab" at the top of the window. Point to Currency and click-on Currency.

Notice several things. The right side shows the number of decimal places. The 2 is the default for cents. We'll use 2. Notice above the Decimal Places that there is a sample of what our number will look like. At the lower right it shows how negative numbers can appear, depending on your choice. When a negative number is calculated, it will appear with your choice. Now click-on OK. All the numbers now have $. If you have large numbers that are "too wide" for the current column width you will see some ######## in the cells where these numbers are located. If you need to, go ahead and widen the columns as you did previously.

 

 

 

 

 

Your spreadsheet numbers should now look like the one on the left.

 

 

 

Up ] Starting Excel 2000 ] Moving Around the Spreadsheet ] Widening Columns ] Inserting Rows ] Aligning Cells ] Saving and Exiting Spreadsheets ] Retrieving Spreadsheets ] Adding Numbers ] Function Pasting ] AutoSum function and Subtraction ] [ More Cell Formatting ] New Page 3 ] Division and Percent ] Copying ] Entering Formulas in Monthly Totals ] Absoluting ] Printing ] Highlighting Multiple Ranges ] Graphics ] More Graphics ]


© Copyright 2007 H-SC | Site Index | E-mail a link | Hampden-Sydney College, Hampden-Sydney, VA 23943 | 434-223-6000 | webmaster@hsc.edu