Other types of content include numbers, dates, times, and Boolean values.
This alignment quickly shows which values Excel considers text.
If the value in A1 isless or equal to 70, the result is “Fail”.
Notice both “Pass” and “Fail” are surrounded with double quotes.
This tells Excel to treat these values as text.
The double quoteswill notbe visible in the final result.
Empty strings will appear as empty double quotes ("").
Empty strings don’t display anything in Excel.
The formula above, when A1 is empty, will return a result that looks like an empty cell.
Enter number as text
Toenter a number as textdirectly in a worksheet (i.e.
not in a formula), precede the number with a single quote character (').
The resulting value will be text, but it will still look like a number.
The single quote will not be visible.
