Spreadsheets are useful at home and in business applications. Spreadsheets make it easy to view and exhibit data in a number of manners. Values are one of the primary types of data used in spreadsheets

## Function

Values are numbers entered into spreadsheet cells. If a formula or function returns a number into a cell, this data is also a value.

## Types

While values are always numerical, there are several categories that can be considered values, such as currency, dates and times and percentages or fractions.

## Considerations

If numbers are entered into a cell, but then the cell is formatted as containing text, the cell will still display a numerical value. However, functions and formulas will not recognize the data as a value.

## Effects

Spreadsheet values can be formatted to appear precisely as needed. For instance, cells can be formatted so that negative values appear in red, in brackets or with a leading minus sign (-).

## Potential

Most spreadsheet programs contain multiple built-in mathematical functions that allow the user to calculate values in a number of complicated manners.