DOnt worry I see the answer is to use the DATE () function

"jonny" wrote:

I am bringing in a date into my excel spreadsheet as a year e.g., 1997. How
do i 'tell' excel that the specific date is actually 31 Dec 1997 and not some
random other day in the year 1997?