to put 1035 in excel without the : type it as `1035 but I think the cell needs to be formatted as general or text. If the cell is formatted for time it has to have the colon to seperate it. excel can see a string (I think) and converts 1035 to the date this string represents. In this case 1902-10-31 00:00:00.
[This message has been edited by spannersatcx (edited 04 March 2001).]