Excel problem

[Pjoter]

Hello!

I hava an application that creates an excel file and writes some data to it. I use this function
Private Sub Plot_The_Name(ByVal nCurrentRow As Integer, ByVal sName As String)
wkbNewBook.ActiveSheet.Range(col & nCurrentRow).Value = sName
End Sub

The problem is that if i write 150/2 to a cell, excel thinks it should calculate this and writes 75 in hte cell.

So does anyone know how to solve this.
There must be someway to set the format of the cell to text or??

Ok I solved it

wkbNewBook.ActiveSheet.Range(col & nCurrentRow).NumberFormat = "@"

Thanks

Pjoter

[Bolerophone]

I use this and it works for me:

wsXL.Cells(10, 10).Value = "110/2"

Amresh