Excell always truncates th Year when i ener it in a spreadsheet why cant i get it to do what i want.
D David A May 15, 2006 #1 Excell always truncates th Year when i ener it in a spreadsheet why cant i get it to do what i want.
B Bernard Liengme May 15, 2006 #2 Change the format to dd/mm/yyyy or in USA to mm/dd/yyyy best wishes
