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