Converting a year date into a specific day date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Back
Top