Pre-format the cell as Text or preface the input with an apsotrophe which won't
show in the cell.

'December 2014


Gord Dibben MS Excel MVP

On Fri, 7 Dec 2007 15:45:58 -0000, "Phil C" wrote:

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