discription:
compatability of the cel with 'date' information like '1-1-2004'
between files saved by excel in the .xls format and files saved
bij openoffice in the .xls format.
When the .xls file is imported in the database filemaker pro 6
the data is good imported fram an .xls file saved by excel
but its bad imported if the same file is saved by openoffice
in the .xls format. Filemaker pro imports de date 1-1-2004 like
the nuber: '37987'

version:
excel 2002 (XP) (englisch version)
openoffice 1.1.0 dutch version
Filemaker pro 6 (6.01v1 englisch version)
file format excel: .xls
file format openoffice: .xls (microsoft excel 97/2000/XP)

example:
the attached files only contains the date '1-1-2004' in the
first cel of the spreadsheet. that's all, the first file is created
in excel and saved in the .xls format

the attached example file: 'date1a_saved_from_excel_2002.xls'
which only contains one cell with the date '1-1-2004' is imported
in the right way by filemaker pro 6.
the same file openend and saved by openoffice as
'date1a_saved_from_openoffice_110.xls' is imported wrong as a number
'37987'.
if this file is opened by excel again and saved as:
'date1b_saved_from_excel_2002.xls' the date is imported by filemaker pro 6
as a date again.

conclusion:
there seems to be a different way in writing the date information in
an .xls file between excel 2002 and openoffice 1.1.0. This doesn't harm the
compatibility between excel 2002 and openoffice 1.1.0. But it has influence
on the import compatibility in other software like Filemaker pro 6