downlaod to Excel sheet using ole

hi,

I am using ole2 method for downloading data into Excel.In the excel all the character fields are left aligned and all the numeric fields are right aligned .

I want all my data to be left aligned ,pls let me know how it can be done thru the program.

Thnx

Bhanu.