>I am using automation to open an Excel spreadsheet from VFP. What I want to do is programatically change the datatype of all cells in the spreadsheet to "text". What is the syntax of the call I would need?
>
>Thanks for your time.
>
>Steve

Try......

Select the column, cell, range, etc and then

oxl.selection.numberformat = "@"