I have entered a column of dates showing just the day and month e.g. 15/10 (15 October). I wish to include the year (last two numbers) - is there any way this can be done without having to enter each date separately ? I tried using 'Format - Numbers - Date' entering the correct year in the first cell and then dragging the mouse over the required cells, but then I get '03' as the year regardless of what I initially entered.
I have just run a test in Excel I entered the dates as: 15/10/03 and 20/10/03 selected the cells and chose a date format and the result was 15 October 2003 and 20 October 2003. You must select the cells before formatting.
This thread is now locked and can not be replied to.