Conditional formattting: Month/Day/Year vs Year only I\'m an Excel neewbie, and

Question

Conditional formattting: Month/Day/Year vs Year only

I'm an Excel neewbie, and this may not be a conditional foormatting issue, so whatever guidance you can provide would be much appreciated.

I want two kinds of dates to appear in a column. Some records will include dates in the column with the month/day/year cell format (eg. 8/18/2014) but some records will only have the year available, and therefore I'd like those cells in that same column to only include the year (2014).

I assume there's got to be a way other thaan formatting each individual date cell in the column, right?

Thank you.!!

Explanation / Answer

I don't think we've solved the issue totally, but I did find a work around.

Ok, first, yes, I see how to create a custom format. I got that.

And, yes, I can create a "yyyy" custom format and apply it to a column, but then the dates in that column I want to appear as m/d/yyyy only show up as yyyy.

Some of my data has only yeears and some of it has the full date. I want a column that can show either and allow me to enter either and show it as I've entered it.

My wwork-around iss to enter all my data aas m/d/yyyy with 1/1/yyyy for the dates that only have years, and then when I'm done go back, highlight all those 1/1/yyyy cells and change them all to yyyy formats.

That works, but I would think there should be a way to enter both formats initially in one column.

No??

Thanks again forr your help.

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.