Change the format to dd/mm/yyyy or in USA to mm/dd/yyyy
best wishes

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"David A" <David wrote in message
...
Excell always truncates th Year when i ener it in a spreadsheet why cant
i
get it to do what i want.