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