I can enter a number as text by

(1) formatting the cell as text
or
(2) leaving the format as general but keying in a single quote with the number e.g. '76.

Either way, the number will be left-aligned with a green triangle i.e. if I invoke error checking. If I untick error checking and don't notice the left alignment, the single quote should alert me that the number is in text format, right?

Do you see another difference between (1) and (2) especially in terms of application of the number (in text format)?

Thanks.

Epinn