>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