excel problem

[sek]

Hi,
I want to assign a value to a cell in the excel file.
i need to assign a text value to a cell.but i am unable to assign the data with leading zeros as they r removed from the excel file after assignment.here below the code i am using.

cRange = XLWorkSheet.Cells.Item(2, 2)
cRange.NumberFormat = "############"
cRange.Value2 = VENDOR_NAME

for example if the data is like below
0000084480

its inserting like
84480

i need zeros also.

how to keep the leading zeros in the cell??i dont want to convert the data into long field as my data contains alphanumeric values.

can anybody help me??

thanks in advance.

 

[Tom]

cRange.NumberFormat = "@"

..................