Thank you.

......possibility of someone choosing (either intentionally or
accidentally) left alignment for the cell......

Good point.

Epinn

"JLatham" <HelpFrom @ Jlathamsite.com.(removethis) wrote in message ...
You aren't going to see the single quote except when you have the cell
selected.

Since there may be possibility of someone choosing (either intentionally or
accidentally) left alignment for the cell, even its position/alignment isn't
a sure bet as a clue.

If you're going 'public' with it, probably best to format the cell as Text
so that the end user won't have to deal with remembering to enter number with
' in front of it?

"Epinn" wrote:

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