Hi,


Excel 2010
I am logging the contents of my Photo negatives,

column subject1, next column date S1, next subject2, next date S2 and so on.
Sometimes I have written on them an exact date, other times a month and year, other times just a year. I have chosen the format for the column that gives 20 March 1987 for example but if the negs are marked Nov 1991 I end up with 01 November 1991., and I wish just to see Nov 1991., as a full date is wrong data.


Furthermore I dont want September but just Sept, as with many columns it making things far too wide.
if I then find the date e.g. 11 Nov 1991 I want that cell to be able to change to that full date.
Many times I have full dates and just M/Y or even Y dates all for the same sheet, so what can I do, ?
I dont need to perform maths on the dates, like establishing the duration between two dates, its just for Photos, maybe to be able to date order the sheet but on the sheet I am currently on the roll number is the deciding factor and thats already in numerical order so no ordering of dates at all.



DBenz