I am using OLE to paste some items from the clipboard into excel (using Cetin's Table2Clipboard program to get it to the clipboard). When I paste it into Excel, character fields that start out with numbers get interpreted as numbers or dates. For example, if the clipboard has

CATEGORY	QUANTITY
	        7
2000:8.2	7
2000:4.1	2
2000:5.6	2
.NULL.	        1
2000:5.4	1

That will get pasted into Excel and turn into:

CATEGORY	QUANTITY
	            7
20:08.2	            7
20:04.1	            2
20:05.6	            2
.NULL.	            1
20:05.4	            1

where the first entry 20:08.2 is really 1/1/1900 9:20:08 AM!!!! If I manually try paste special -- text , it still doesn't work. Do any of you have any thoughts on the subject?

Thanks,

Kevin