Sub ee()
Dim sStr As String, sStr1 As String
sStr = "01/18/2006"
MsgBox sStr
sStr1 = Replace(sStr, "/", ".")
MsgBox sStr1
End Sub

--
Regards,
Tom Ogilvy

" wrote:

Thanks Carim ...

I need a VBA solution that works on a String.