What statement is not true about the differences between text and values in Excel?

Question $5$ options:

A numeric can be converted to text by appending a single quote, as in zip code $\text{'}04401$

If a column cannot fully display a numeric value, error message ##### appears.

A cell containing text, like the word "cat", cannot be used in a math formula.

If a column cannot fully display a text entry and the cell to the right is occupied, error message ##### appears.