Great! Just what I needed / Jim
>>I'm exporting a table to Excel by copying it to the clipboard (using _vfp.datatoclip) and then pasting it in Excel.
>>
>>However, I'm having problem with character data that "looks like" data of some other data type. For instance, I have a field which is length of time, and which looks like hours and minutes (2:02, 4:15, etc). Excel is thoughtful enough to convert these to time-of-day.
>>
>>Is there some way to force Excel to accept character data and not try to be so handy as to do conversion for me?
>>
>>Thanks
>
>Yes, if you give the Excel cells a corresponding format, for instance, "Text", before inserting the values, it should not interpret your data.
Jim Nelson
Newbury Park, CA