This is silly. I found this post which jerry-rigs a solution but doesn't solve the problem...
http://www.mrexcel.com/board2/viewtopic.php?t=98792&highlight=recognize+month+year
If I have a column of dates in DD/MM/YYYY format (I.e. 23/06/2006), how do I get get Excel to recognize it as a date and format it accordingly, as opposed to me having to 'flip' the days and months first?
There's got to be a way...
http://www.mrexcel.com/board2/viewtopic.php?t=98792&highlight=recognize+month+year
If I have a column of dates in DD/MM/YYYY format (I.e. 23/06/2006), how do I get get Excel to recognize it as a date and format it accordingly, as opposed to me having to 'flip' the days and months first?
There's got to be a way...
