Unfortunately this is not an option. The spread sheets are used for reports and to move data to other systems.



>>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.
>
>Fred,
>
>What I do to avoid this is..
>
>When a field is of type T_CHARACTER or T_MEMO
>

>xlSheet.Cells[nRow,i].Value = ['] + Table.Field
>

>This is basically what you do in excel. If you want 600 to be treated as a string you enter '600