0
How to stop excel changing date format?
I type in 05/11/2014 as in fifth November and it displays 11 May 2014 in the cell
Yet in the cell content line at the top of the sheet it still displays 05/11/2014.
EDIT
I have chosen dd/mmm/yyyy cell format from the cellformat menu. And indeed it is displaying day month year. but it is not displaying the day month year I enter.
Go to Control Panel -> Region and Language. Make sure it is set to the correct (desired) format – Dave – 2014-08-07T08:59:09.600