I'd like to know if there are differences in the following ways that Excel allows to display text/string in cells (regarding VBA usage):
To illustrate what I mean: let's say I have the string Example.
Excel allows to display this string in several simple ways:
1. Simply type in the string you want, in which both the value and the cell's text properties are one and the same ("Example").
2. Type in an apostraphy proceeding your string, as in: 'Example, in which both the Value and Text properties of the cell are still pretty close
(I suppose that here the cell's format is being explicity set to text in one strock, right?).
3. Type in a formula that returns a fixed string, as in: ="Example" in which the Value and Text properties are more apparently different.
And there is another way which is more dynamic (usign "non-self-returning" formulas as seen in 3), but this is not as relevant to my question as I focus on a rather fixed way of displaying a string.
So other than the obvious differences I pointed out (Value vs Text), is there a difference in them?