Bob Long wrote:

Andreas Saeger wrote:
When you format a cell as text it will treat any input as text, even if it is numeric or starting with a "=".

Is that really true? I've not been able to confirm that.
Yes, it's true, and I'm guessing that this is the only time you need to use the Text format, i.e. when the content MUST be text irrespective of content, e.g. when you want to enter phone numbers as text. Otherwise, any "Number" format will usually handle text ok.

Ross

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to