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!
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!