The basic structure here would be :-

'----------------------------------------------
If .......... Then
'code
ElseIf ............ Then
'code
ElseIf ........... Then
'code
Else
'code
End If
'-----------------------------------------

You could presumably do a similar search for ":" to get time, or you
might find this useful :-

If IsNumber(c.Value) Then c.Value = "number"


---
Message posted from http://www.ExcelForum.com/