Formatting Excel 2010 Data

Sorted by:  

Excel 2010's Three Data Types and Their Default Formats

In Excel 2010, the worksheet consists of a grid of columns and rows that form cells. You enter three types of data in cells: labels, values, and formulas. [more…]

Formatting Dates in Excel 2010

Excel 2010 provides several different formats in which to display dates and times in a worksheet. Some date formats appear automatically based on how you type a date entry in a cell. For example, if you [more…]

How to Change a Cell's Number Format in Excel 2010

Excel 2010 provides a variety of number formats that you can apply to the values (numbers) you enter in a worksheet to make the data easier to interpret. These number formats include currency, accounting [more…]

How to Display Numbers in Excel 2010 as Currency

Many Excel 2010 worksheets include financial data, so you'll likely use either the Currency or Accounting number format when working with this data. You can easily assign these formats to selected cells [more…]

Working with the Comma Style in Excel 2010

The Comma Style format (also known as the thousands separator) in Excel 2010 often accompanies the Accounting number format. Like the Accounting format, the Comma format inserts commas in larger numbers [more…]

How to Apply the Percent Number Format in Excel 2010

Many Excel 2010 worksheets use percentages in the form of interest rates, growth rates, inflation rates, and so on. When you apply the Percent Style format to a value that has already been entered in a [more…]

How to Use Excel 2010's Special Number Formats

Excel 2010 includes a nifty number format category called Special that contains four formats: Zip Code, Zip Code + 4, Phone Number, and Social Security Number. These Special number formats, described below [more…]

How to Copy Excel 2010 Formatting with Format Painter

Use the Format Painter button on the Home tab of the Excel 2010 Ribbon to save time when copying formatting between cells in your worksheets. You also can use Format Painter to quickly copy the width of [more…]

How to Insert Decimal Points Automatically in Excel 2010

If you need to enter a bunch of numbers in an Excel 2010 worksheet that use the same number of decimal places, you can turn on Excel’s Fixed Decimal setting and have the program enter the decimals for [more…]

Learning anything is easy with For Dummies eLearning!

Sign Up for RSS Feeds

Computers & Software