Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Character data mangled with datatoclip into Excel
Message
From
14/12/2004 18:30:58
 
 
To
13/12/2004 19:21:50
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP1
Miscellaneous
Thread ID:
00968947
Message ID:
00969304
Views:
11
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
Previous
Reply
Map
View

Click here to load this message in the networking platform