Hi,

Yesterday I almost lost the remaining hairs in my almost bald head :(

Below is a simple sequence that reproduces the behavior I was experimenting.

My program generated a cursor (with many columns) and there was some columns with dates and other with numeric calculated values. After filling the cursor with many rows it was exported to Excel.

Due to a logic error my program was generating numeric overflow when storing some numeric values into cursor numeric columns. Till this point it's all ok, BUT, when I looked at the resulting Excel spreadsheet the result was not only overflow in those numeric columns, but ALSO in some date columns. Want to check it? Just run the prg below.

Create Cursor Test (Field1 D, Field2 N (1), Field3 D)

dDate = Date ()

For I = 1 To 20
    Insert Into Test (Field1, Field2, Field3) ;
              Values (dDate , I     , dDate )
EndFor

Select Test
Browse
Export To C:\Temp\Test.xls Type XL5

Is that a bug in Excel, VFP or what? Note that in the browse window all dates are ok.

Fernando