1. Home
  2. Computing & Technology
  3. Spreadsheets

Entering Data in Excel

By Ted French, About.com

6 of 8

Types of Data in Excel

Examples of 3 data types used in Excel

The 3 data types used in Excel

© Ted French

Types of data in Excel There are three different types of data in Excel:

  • labels
  • values
  • dates/times

A label is an entry that is usually used for headings, names, and for identifying columns of data. Labels can contain letters and numbers. By default, labels are left aligned in a cell.

A value contains numbers and can be used in calculations. By default, values are right aligned in a cell.

Date/time data is just that, a date or the time entered into a cell. By default, date/time data is right aligned in a cell. Sometimes dates are combined with numbers and considered to be values instead of a separate type of data.

Return to Index page

Explore Spreadsheets
About.com Special Features

Stay connected and entertained with reviews on tips on the latest HDTVs, cellphones and more. More >

Easy ways to connect two computers for networking purposes. More >

  1. Home
  2. Computing & Technology
  3. Spreadsheets
  4. Excel 101
  5. Excel Data Types - ThreeTypes of Data in Excel - Labels - Values - Date and Time

©2009 About.com, a part of The New York Times Company.

All rights reserved.