Entering constant values in worksheet cells

Add constant values to both spreadsheet and database cells to provide labels or other explanatory information. Constant values consist of numbers, spaces, non-numeric characters, or any combination of these. Constant values are not part of a formula or the result of a formula.

The formula phrase “=1”, or any number following an equal sign, is also considered a constant value.

Select the cell, and then enter the text or numbers needed; your entries automatically display in the worksheet Formula bar. When you click the green check mark on the Formula bar, the value displays in the cell.

Keep in mind the following:

Most constant values are treated as text and default to the General format. However, some combinations of numeric and non-numeric characters are interpreted as a particular number format. For example, an entry of 07/19/2021 automatically changes the format to the month/day/year date format. (See Formatting worksheet cells.)

Text is left-aligned unless the cell is formatted differently on the Alignment tab in the Format Cells dialog box (select Format > Cells from the Worksheet menu).

Numbers entered in cells default to the General format. To change them to another format (for example, dimension or fractional), select Format > Cells from the Worksheet menu, and select the new format on the Number tab in the Format Cells dialog box.

Entering formulas in worksheet cells

Inserting images in worksheet cells

 

Was this page helpful?