Why didn't you say so?
I didn't understand you the first time.
Now we're getting somewhere.

11/8/2000 1:03:06 PM
11/8/2000

Use the Left function.

Left(Text1.text, 9) 'returns 11/8/2000

Or you can use the Mid function.

Mid(Text1.text, 1, 9) 'returns 11/8/2000