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
Jim Nelson
Newbury Park, CA