>hi all,
>I have an application that creates an excel file and have 2 problems.
>I need to format the cels to save them work so that they can enter something like 01/98 without excel trying to be clever and turning that into a date. I have tried the following
>

>OleApp.cells(lnCounter,4).NumberFormat = "@"
>

>but that does not work

For your first problem you have to set Fomat property to be "Text" before (not after) entering a value.

However, using Excel 2007 I could not figure out at the moment how to record a macro (don't see option/button), so can not translate it exactly into the code.


>My second problem is when reading the file back in I have a column that has a formula in it sum(G1*H1) but when I read it in I get errors. Normally when i read in from excel there is not a formula in the cell and this is the first time doing this, any pointer please.
>~M