@SteveRichter:If I want to force a cell to be text, then I usually apply a ' (single-quote) prefix to it. Excel knows to ignore that character, and treat it as a 'format as text' operator.