I have a file that I am exporting to Excel but one of the fields is a date field. When it is exported to Excel, it is shown as numbers eg. 36568 instead of 09/03/2000. The only way i can change it is in excel to change the format of the cell. Is there a way to change the format before excel is even open (in paradox). Thank you for any help.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Paradox and Excel
- Thread starter Tamara
- Start date
Tamara, I really think you should continue to export the field as a numeric date value. Only a few months ago, just before Y2k, I swore I would get angry at any programmer I ever caught trying to convert a date to a string. Well, I'm older now and the horrors of the conversions are beginning to fade.... but, please, don't go that way. Format a date column in Excel to receive the exported values.
[sig]<p> <br><a href=mailto: > </a><br><a href= plain black box</a><br>[/sig]
[sig]<p> <br><a href=mailto: > </a><br><a href= plain black box</a><br>[/sig]
- Status
Similar threads
- Locked
- Helpful tip
- Locked
- Question