The "@" symbol worked. Thanks.

I don't understand what you mean by "recording a macro within excel". I
really haven't done any macros in Excel, nor any VBA. I've only programmed in
..NET C#, using Visual Studio Tools For Office.

"Dave Peterson" wrote:

myRange.numberformat = "@"

Sometimes you can get the answer by recording a macro within excel.