Terry,

I believe, that your reply should go to the originator, but not to me.

>In addition - sometimes its faster to VFP copy a cursor XLS - and then open the spread sheet and make your column header changes - rather than iterate through each record and formatting each cell.
>
>>Examples are below, though they may not represent what you actually need.
>>Try to record a macro in Excel when formatting columns/cells as you need, and translate vba code to foxpro.
>>
>>Objexcel.Range("b4").NumberFormat = "0;-0;;@"
>>Objexcel.columns("B:B").NumberFormat ="$#,##0.00_);[Red]($#,##0.00);;@"
>>
>>>Does anyone have a code example of formatting a cell through automation?
>>>
>>>I create spread sheets through automation and unfortunately, some columns have numbers with leading zeros. The leading zeros are removed unless I change category to text in the Format Cells dialog.
>>>
>>>Thanx.