How do I stop Excel from turning November 2006 into Nov-06?

[Jessamine]

Excel is driving me mad. How can I permanently turn off the function which
converts dates entered as November 2006 to Nov-06?

[Ardus Petus]

Format column as mmmm aaaa

HTH
--
AP

"Jessamine" <[email protected]> a écrit dans le message de
news: [email protected]...
> Excel is driving me mad. How can I permanently turn off the function
> which
> converts dates entered as November 2006 to Nov-06?

[saziz]

Select the cell -> Format-> cells->date and then choose whatever you like.
Syed