How2CellFormat2007xlsx

How2CellFormat2007xlsx - TIP 1: HOW TO CELL FORMAT AN EXCEL...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
TIP 1: HOW TO CELL FORMAT AN EXCEL WORKSHEET? note: It is assumed that you know how to locate various Excel icons and place them on the Quick Access Tool Bar. If not, please watch the short Audio+Video called QAT. Say you have completed an Excel worksheet and the numbers have all checked out! The next logical thing to do is to correctly format each cell. In a typical worksheet, there are THREE types of cells. Dollar or amount cells. Typically formatted as dollars and cents. Accounting is the default format, with the $ left justified, even for a small dollar amount. The $ or dollar icon in the formatting toolbar is pre-programmed to apply this format. Percentage or decimal cells. Typically formatted as a percentage, with two decimals. Sometimes, you may want to show even four decimal places, for really small numbers. The % or percent icon in the formatting toolbar is pre-programmed to apply this format. When you click the % icon, the cell is displayed in percentage format, but with no decimals. Increase to two decimals using the increase
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 04/15/2011 for the course DSCI 2710 taught by Professor Hossain during the Spring '08 term at North Texas.

Ask a homework question - tutors are online