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

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

Recording a macro in Excel gives the NumberFormat property of the Selection
or Range object. Text format is "@".

HTH
Ed

"Bill Henning" <please @ nospamforactiprosoftware.com wrote in message
...
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