>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.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)