Microsoft KB Archive/101288: Difference between revisions
(importing KB archive) |
m (Text replacement - """ to """) |
||
Line 41: | Line 41: | ||
# Select cell B2, type | # Select cell B2, type "=DATEVALUE(A2)" (without the quotation marks),and then press Enter. | ||
# Select cell B2 again. From the '''Edit''' menu, choose '''Copy'''. | # Select cell B2 again. From the '''Edit''' menu, choose '''Copy'''. | ||
# Select cell C2. From the '''Edit''' menu, choose '''Paste Special'''. | # Select cell C2. From the '''Edit''' menu, choose '''Paste Special'''. |
Latest revision as of 09:21, 20 July 2020
The information in this article applies to:
SYMPTOMSWhen you export a FoxPro database containing a DATE field to Microsoft Excel, the resulting spreadsheet contains the date as a general expression. This problem often results in an incorrect date format on the Microsoft Excel spreadsheet.
CAUSEFoxPro exports data from a .DBF file as unformatted text strings.
RESOLUTIONTo correct this problem, do the following in Microsoft Excel 5.0:
The date will now be in the correct format.
STATUSThis behavior is by design.
MORE INFORMATIONSteps to Reproduce BehaviorNOTE: These steps create a spreadsheet called TESTDATE.XLS. They also assume that you are using Microsoft Excel 5.0.
Note that All is selected under Category and General is selected under Format Codes. (Date would be selected under Category if the cell was formatted as a date field.) Additional query words: spread sheet tshoot Keywords : kbinterop FoxDos FoxWin FxinteropSpread KBQ Version : MS-DOS:2.0,2.5,2.5a,2.5b,2.6,2.6a; WINDOWS:2.5,2.5a,2.5b,2.6,2.6a Platform : MS-DOS WINDOWS Issue type : kbprb |
Last Reviewed: April 26, 1999 |