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.