One way:

rng.Numberformat = "@"

In article ,
"Bill Henning" <please @ nospamforactiprosoftware.com wrote:

Hi there... I'm using an Excel object model component in Visual FoxPro to
write data to an excel sheet. It's the same as the Microsoft Excel object
model.

I've gotten the data written out but there are columns in which some rows
have character data and some have numbers. I want to apply "Text"
formatting instead of "General" formatting to these cells. However for the
life of me, I can't figure out what property/method in the Excel object
model to use to make the Range formatted as "Text". Can someone point me to
what I need? Thanks!

Bill