I'm automating Excel from vb. I've a sheet object and I'm assigning

l_oSheet.Cells(Row,Col).FormulaR1C1 = CStr("03")

If I step it when I look at the contents of
l_oSheet.Cells(Row,Col).FormulaR1C1, It shows it is 3. I don't actually want
that but what I've assigned i.e. "03".

Do I have to set some other column property or assign to a different cell
property?

Thanks

Simon

Hi Simon,

try this line before

l_oSheet.Cells(Row,Col).NumberFormat = "@"

Regards,
ste

Excellent thanks

"ste" wrote in message
ups.com...
Hi Simon,

try this line before

l_oSheet.Cells(Row,Col).NumberFormat = "@"

Regards,
ste