|You need to understand how Excel stores dates, here is a quote from MS:|
"Excel stores all dates as integers and all times as decimal fractions. With this system, Excel can add, subtract, or compare dates and times just like any other numbers, and all dates are manipulated by using this system.
In this system, the serial number 1 represents 1/1/1900 12:00:00 a.m.
Times are stored as decimal numbers between .0 and .99999, where .0 is 00:00:00 and .99999 is 23:59:59.
The date integers and time decimal fractions can be combined to create numbers that have a decimal and an integer portion.
For example, the number 32331.06 represents the date and time 7/7/1988 1:26:24 a.m."
So, with that being said, just entering the year 1983, as you know, gives you a Date of 6/5/1905 or 1983 days since 1/1/1900.
You cannot get just the Year alone, as Excel does not understand it as a Date.
You could try using 01/01/1983 and then using a Custom Format to display it as just the year by using YYYY.