Text Number Format

Glossaries

Term	Definition
Text Number Format	Glossaries - Excel Terminology The Text Number Format instructs Excel to display the text in the cell, but more importantly, instructs Excel to store any values entered into the cell as text strings, regardless of whether they look like intrinsic values or a formula. Leading zeroes, such as in account and telephone numbers are therefore preserved. The Text Number Format code is @. See the Ready Reference on this site for information on number formatting codes.

Term

Definition

Glossaries - Excel Terminology

The Text Number Format instructs Excel to display the text in the cell, but more importantly, instructs Excel to store any values entered into the cell as text strings, regardless of whether they look like intrinsic values or a formula. Leading zeroes, such as in account and telephone numbers are therefore preserved. The Text Number Format code is @. See the Ready Reference on this site for information on number formatting codes.