See
Importing Excel Files - Date Problem Message #
548906.
>Hi
>
>I am importing some data from an XLS spreadsheet using the IMPORT command. Unfortunately one of the fields is a date comes through as an number which I assume is some type of julian date but it will not convert using
>
>
SYS(10,[number])
>
>eg.
>my number : SYS(10,37383) returns "//"
>
>whereas
>
>another number : SYS(10,2452406) returns 05/06/2002
>
>I assume this is because my imported number (being much smaller) is "based" differently.
>
>Can any one tell me how to correctly convert the IMPORTed number.
>
>Regards
>Geoff Scott
--sb--