FormulaR1C1 - autoconverting strings to numerics

[Simon Woods]

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

[ste]

Hi Simon,

try this line before

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

Regards,
ste

[Simon Woods]

Excellent thanks

"ste" <[email protected]> wrote in message
news:[email protected]...
> Hi Simon,
>
> try this line before
>
> l_oSheet.Cells(Row,Col).NumberFormat = "@"
>
> Regards,
> ste
>