Text and Date in Same Cell?

[jdpro]

Hi,

I would like to enter a date and text in the same cell. When I auto-fill a series of dates with my preferred date format, and then attempt to enter text in some of the cells, the date format changes. I want to have 6-May, but when I enter text to follow the date, it changes to 5/6/2016. In each cell that I want to include text I am forced to retype the date manually to get it to format the way I want it to.

Is there a way to resolve this?

Thank you in advance for any help!

 

[FDibbins]

the A1 and B1 were just theoretical references to where your data may be.

A1 was a reference to your data cell, and B1 was a reference to where the term "cancelled" would be entered