Converting a year date into a specific day date

J

jonny

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Countdown macro - display settings 2
Date format 5
graph by month/year a count of a list of dates 0
Autofill Date in Word 15.33 for Mac 0
Excel date intervals look up 1
Date Difference in Complete Tax Years 1
multiple vlookup; index/match 2
How To Combine Several Rows of Data into 1 Row of Data 3

Top