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 field. 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/2025 automatically changes the format to the month/day/year date format. (See Worksheet: Format tab.)
Text is left-aligned unless the cell is aligned differently on the Format tab of the tool bar.
Numbers entered in cells default to the General format. To change them to another number format (for example, dimension or fractional), select Number Format from the Format tab.
