"Phil C" wrote in message
...
Hi All

When I type "December 2014" into a cell and hit return, Excel
automatically changes it to "Dec-14".
How do I stop it doing this?!
Can't find anything in Tools|Options.

Thanks, Phil


Precede your typing with an apostrophe like this:
'December 2014

This will enter it as text and Excel will not try to convert it to a date.

Alternatively, format the cell as text BEFORE typing ito it.