hangover

I think the number is probably an Excel DateValue - this is how Excel stores dates (it is the number of days since 31 December 1899).

It might be easier to import the values into a FoxPro date field and then convert them to text if required in FoxPro. Alternatively, if you want to import the dates into a character field then it might be possible to do this by converting them to text values in Excel first. One way of doing this is using a formula. If your dates are in column B starting at row 1, insert a new column next to it (i.e. column C) and enter this formula in cell C1 =TEXT(B1,"DD/MM/YYYY"). Copy this formula down so that you have a corresponding text value for every date. Now select Column B and format all the cells as text. And then copy column C and use Paste Special ... Values to transfer them to column B. All your dates should now be converted to text values. Now delete column C and try saving the file and importing it into FoxPro.

Hope this helps.